Syntax for storing query results from one server to another server

[kbaisch]

Can someone help me?
I'm executing a stored procedure that runs a query. That works fine.
I need the syntax to tell the stored procedure to save it to another server in a folder. Any help would be much appreciated.

Thanks in advance.

[Purple]

Hi kbaisch,

Can you post the stored procedure so we can see what you are doing

Regards Purple

[kbaisch]

this is the stored procedure I have to run the query on the deh05 server. Now i need to send this information to a folder in my deh02 server.


/*
Name: Testmovetofolders
Description: Move queries to folders on deh02
Author: Kim Baisch
Modification Log:

Description Date Changed By
Created procedure 06/14/07
*/


CREATE PROCEDURE .[Testmovetofolders] AS
SELECT TOP 100 PERCENT dbo.Medicaid_cur.Name_, dbo.Medicaid_cur.Sex_, dbo.Medicaid_cur.DOB_, dbo.Medicaid_cur.Residence_,
dbo.Medicaid_cur.Case#_, dbo.Medicaid_cur.Race_, dbo.Medicaid_cur.Elg_, dbo.Medicaid_cur.Sub_, dbo.Medicaid_cur.EligBegin_,
dbo.Medicaid_cur.EligEnd_, dbo.Medicaid_cur.SSN_, dbo.Medicaid_cur.Stat_, dbo.Medicaid_cur.EligMax_, dbo.Medicaid_cur.CurMth_,
dbo.Medicaid_cur.TPLCode_
FROM dbo.Medicaid_cur INNER JOIN
dbo.VIEW1_3TABLES ON dbo.Medicaid_cur.Residence_ = dbo.VIEW1_3TABLES.MRCityState_ID
WHERE (dbo.VIEW1_3TABLES.AreaName = N'ANMC BUSINESS OFFICE')
GO

[Purple]

Hi kbaisch,

connect to your remote server and run the create procedure SQL statement as posted previously which will create the stored procedure.

Post back if you need clarification

Regards Purple

[kbaisch]

I'm sorry, I'm not very good at explaining. I'll try again....

I want to add more script to this procedure telling it to save this as a "certain file" ie, xls, doc, etc. and telling it where to save it on a server in a folder. I don't know how to write that. Can you help me with that?

Thank you for your help.

[gpinetto]

Hi I think you must use User-Define functions with clr integrations to do this