General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
How to save data in a file
Hi,
I have a stored procedure that accepts one parameter. It returns 200 rows and three columns as it has select statement. I want to run it number of times there is value in states table and wants to store the out put in excel file. Since it will run 53 times with state name as parameter I used the cursor to run it. Here is an example. Can anyone tell me how to copy the out put into the excel file with new name with each run of stored procedure.
DECLARE State_cursor CURSOR
FOR
SELECT cstate
FROM states
OPEN State_cursor
DECLARE @cstate varchar(2)
FETCH NEXT FROM State_cursor INTO @cstate
WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF (@@FETCH_STATUS <> -2)
BEGIN
exec Bsp_Prov_report @cstate
END
FETCH NEXT FROM State_cursor INTO @cstate
END
CLOSE State_cursor
DEALLOCATE State_cursor
Thanks
Bharat
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only