Exporting Report Data to Case Management System

I work for a large government organisation and I have built several reports
that enable clients to drill down to case level which they love. The problem
is that now they all want to be able to "push a button" and send the cases to
a case management system. I know how to write the code to send the cases to
the case management system tables but I don't know how to enable the client
to be able to trigger it from the report interface. Any assistance would be
much appreciated!Well this depends on how you want to do it... right now I assume they view
the reports from a browser right? If so, you may want to look into
customizing a front end to view the reports - or you can simply create a
smart client where you have a button on a form and the reports are listed
that can be exported to the case management system.
The last option is to create a delivery extension, which I think would be
the best thing to do, you select the report, and the new output to render to
if you will. :)
=-Chris
"St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
news:1BCF18A3-5568-41F7-B69B-A948828A0625@.microsoft.com...
>I work for a large government organisation and I have built several reports
> that enable clients to drill down to case level which they love. The
> problem
> is that now they all want to be able to "push a button" and send the cases
> to
> a case management system. I know how to write the code to send the cases
> to
> the case management system tables but I don't know how to enable the
> client
> to be able to trigger it from the report interface. Any assistance would
> be
> much appreciated!

Exporting from MSDE to SQL Server

Hi All,

I recently created my entire site before even starting to look at hosting providers. It's a very complex ASP.NET e-Commerce site built on SQL Server. I've (nearly) got it to a point where I want it to go live.

I found a host that caters for all my needs and is a good price. What I need to do now is migrate all my data, as well as all my tables and stored procedures, into the database with my host.

Is there an easy wy to go about this?

- Mina

I would install SQL Server backup your databases and restore it in SQL Server with same name if you use the restore from Device option in the backup wizard and SQL Server will move everything for you including permissions. Then moving to the host provider will be easy because SQL Sever Enterprise Manager is needed to move your databases with most Host Companies. Hope this helps.|||You need to talk to your hosting provider -- the easiest way toaccomplish this will be to simply send them the detached MDF and LDFfiles and have the provider attach them. Whether or not they'rewilling to do that is another question

Exporting data from Excel Tables to SQL Server Tables

Hi all,

I have a large Excel file with one large table which contains data, i've built a SQL Server DataBase and i want to fill it with the data from the excel file.

How can it be done?

Thanks, Michael.

If you are using SQL 2000 Standard or better, use DTS.

If you are using SQL2005/8 Standard or better, use SSIS.

If you are using SQL 2005/8 Express, get the Graphical User Interface for it and try that out.

p.s. What version of SQL Server are using?

Exporting

Hi

I built a new sql server database and want to export its content to a .sql file. How to do it? (EM, QA ?) Thanks

Exporting the tables,views,sp ... can be done using the SQL Managment Studio. Right click and script the database.

If you want to export data then you will need a software that will generate the INSERT queries. Search google about SQL scripting ...

HTH
Regards

Export to text file

Is there any built in functions in sql server that allow you to export data
from sql server to a flat file without using xp_cmdshell?
I would like to do this through an application where the user login wouldn't
need symin rights and have the sql server actually create the file simila
r
to calling bcp through xp_cmdshell.
ThanksWrap it in a Stored Procedure, giving the user EXECUTE rights on the stored
procedure. Set up the proxy account.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"John" <John@.discussions.microsoft.com> wrote in message
news:474BA5A0-7AA3-4393-ABE0-02F72079E4AE@.microsoft.com...
> Is there any built in functions in sql server that allow you to export
> data
> from sql server to a flat file without using xp_cmdshell?
> I would like to do this through an application where the user login
> wouldn't
> need symin rights and have the sql server actually create the file
> similar
> to calling bcp through xp_cmdshell.
> Thanks|||Thanks. I kind of figured something like that. I'm actually having a
problem with the constant syntax though.
Arnie Rowland wrote:
> Wrap it in a Stored Procedure, giving the user EXECUTE rights on the store
d
> procedure. Set up the proxy account.
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:474BA5A0-7AA3-4393-ABE0-02F72079E4AE@.microsoft.com...|||I think declaring a variable and setting its value is the way I need to
go(?), but I don't want to insert or replace any values in the table. I
want to take information that isn't in the table (the account number)
and append it to the beginning of what gets pulled from the table. I'm
about how and where to make it happen in SQL 2000.
birdbyte@.gmail.com wrote:
> Thanks. I kind of figured something like that. I'm actually having a
> problem with the constant syntax though.
> Arnie Rowland wrote: