By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,787 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Storing results in different files.

100+
P: 123
Hi all,
I am using Microsoft 's query analyzer.
My query results in a huge number of data. I wanted to store first 500 records into one file.E.g result1.csv and other 500 into result2.csv and so on with result3.csv etc.

How can i do so? Right now I am manually pasting those results into different files. Is there any way with query analyzer to do automatically.?

Thanks...
Dec 2 '08 #1
Share this Question
Share on Google+
3 Replies


Atli
Expert 5K+
P: 5,058
Hi.

Assuming Microsoft's SQL Query Analyzer is only intended for Microsoft's SQL Server, I am moving this thread over to the SQL Server forum.

Please try to post your questions in the appropriate forums.

Thank you.
Moderator
Dec 4 '08 #2

ck9663
Expert 2.5K+
P: 2,878
You might need to create a small batch/script that will do a loop that breaks your table into the required number of records.

-- CK
Dec 4 '08 #3

100+
P: 123
To Atli :
Oh sorry !
I will keep in mind next time.

To Ck9663
I will try out doing that way !
Thanks for your suggestion ..

-Ajd335
Dec 4 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.