Lynn Pettis (9/15/2009)
That was not obvious based on your original post. There was nothing there to indicate how many rows were to be deleted.
He did say there was a set number of known rows... 🙂
Aside from that though, thoroughly agree - there's not even that much point in counting the rows first - you might as well just get on with it...
Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone