468,242 Members | 1,459 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

Storing results in different files.

123 100+
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
3 1343
Atli
5,058 Expert 4TB
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
2,878 Expert 2GB
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
ajd335
123 100+
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.

Similar topics

6 posts views Thread by Kieran Benton | last post: by
5 posts views Thread by | last post: by
3 posts views Thread by Lucky_Syringe | last post: by
14 posts views Thread by Archanak | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.