Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement