sql server (alternate): royal344 (royal344.news.invalid@web2news.net) writes:
[quoted text, click to view]

Do you want any 100000 rows?

You could use BCP and make use of the options for specifying first and
last row. I don't recall the exact name for these options right, but
you can look up the syntax for BCP in Books Online.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at

I have a table in mssql7 that has 7000000 record and I want to take
100000 records out of it and place them into the new machine with
mssql2000. The new machine will also have the same table name, so I
want to append the 100000 records into that table.


Thanks,
Royal344
--
Direct access to this group with http://web2news.com