Deleting Set of Rows

[Alan]

Based on no order whatsoever, you do a query on one table. Let`s say 10000 records come up, and you want to get rid of the first 2000. Is there an easy way to do this? Let me know. Thanks.

[VK]

Just execute command:
SET ROWCOUNT 2000
GO
Than instead of your SELECT run your DELETE.

VK.