Append first 3000 rows into table

[Aett]

Greetings all,

what command do I need to use to append the first or top 3000 rows from 1 table to another?

Thank you in advance.

 

[PHV]

INSERT INTO [another table] SELECT TOP 3000 * FROM [1 table] ORDER BY yourSortField(s)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Aett]

Yes it helped, thank you!