May 14, 2013 at 10:04 am
Hello all,
I have a huge query that produces 800.000 lines of messages how can i save the output to a table? Is that possible since i have tried it on a file to export it and it didnt work.
Much appreciate your help
Z
May 14, 2013 at 10:12 am
Not much to go on here, especially since we can't see what you see. Care to provide more details, perhaps even post the code for the proc?
May 14, 2013 at 10:13 am
What messages, exactly? Are you sure that they're messages and not simply the results of the query being displayed to text?
Can you please provide the DDL statements for the tables you are accessing, along with the query that you're running to produce the messages?
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
May 14, 2013 at 10:19 am
Yes they are the results of a huge sql process that does a lot of things, and the results are diplayed but cant go through them since they are 800.000 rows of those type of messages
(151 row(s) affected) . is there any way to only output the errors and not the succesful messages or save those to a table?
May 14, 2013 at 10:24 am
zouzou (5/14/2013)
Yes they are the results of a huge sql process that does a lot of things, and the results are diplayed but cant go through them since they are 800.000 rows of those type of messages(151 row(s) affected) . is there any way to only output the errors and not the succesful messages or save those to a table?
These, (151 row(s) affected), can be eliminated by putting SET NOCOUNT ON at the start of the procedure.
May 14, 2013 at 10:25 am
ok thanks will try that for sure and let you know
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply