split Tables

[Compkitty]

Is there a way to take a table w/ ie. (225,000,000) lines in it and split into 1125 files of 200,000 lines and BCP those out into csv files???

 

[nomadicalloy]

yes you can do that. Just do querry out top 200000 rows at a time on the bcp export.



SQL Help Blog

http://www.xpherion.com/blog.asp

 

[Compkitty]

Ok, So If I do JobA BCP SELECT TOP 200000 From the table, what do I do w/ those records after the output when I'm ready to do the next set of 200,000??

Ie
JOB A is rows 1 - 199,999 DONE
So then Job b will be Select top 200000 From table.. would that mean it's just replication job a?? rows 1 - 199,999??

 

[nomadicalloy]

you can keep a temp table of some sort with id of rec's sent to csv file and then next batch exclude those recs.



SQL Help Blog

http://www.xpherion.com/blog.asp