Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sending output to, um, something useful
Message
 
To
13/06/2008 09:03:28
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323772
Message ID:
01323787
Views:
15
This message has been marked as the solution to the initial question of the thread.
>I want to take what is being sent to the grid, or text in the results window via the PRINT command, and put it in a a table/cursor so I can move through it and do some processing on each row. How can I do that?

I'm not sure what you want.
If you want just to put results from a PRINT command to some table, the you could use Table variable to store messages there.
DECLARE  @Prt TABLE (Id int IDENTITY(1,1), Description varchar(8000))

DECLARE @i int
SET @i = 0
WHILE @i < 500
     BEGIN
         print @i
         INSERT INTO @Prt (Description ) VALUES ('Main loop @i = '+CAST(@i as varchar(30)))
        SET @i = @i + 1
   END

SELECT * FROM @Prt
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform