limit records

[lcross]

i want to run a querie to criate new tables every 200 records, how can this be done?

 

[ColinEssex]

Why?

Col

 

[lcross]

cause i have a table with more than 1800000 and i need to break it for a txt file

 

[lcross]

cause i have a table with more than 1800000 records and i need to break it for a txt file

 

[ColinEssex]

1million 800 thousand records is going to create 9000 tables.

Good luck

Col

 

[lcross]

yes i know but can tell me how its done???