Thanks to every one for the quick help. This works fine for a table. One more help I need.

I have a partitioned view in which I have all these tables joined using union.

If I try to delete using TOP , it will not allow.

Also, I tried setting the rowcount to 10000 and run the delete. But it is ignoring the rowcount limit as it is a view.

What is the alternative here ?