General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
>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
Bharat,
If you open Excel with a blank spreadsheet and run "New Database Query" from the tools menu, you can get the data into the spreadsheet. You cannot create a spreadsheet from within SQL server.
Previous
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