LoveSQL (3/10/2009)
Well the back end is SQL 2000 not SQL 2005thanks!
Heh... understood. And I agree with Micheal, it would have been better if you posted your question in the SQL Server 2000 forum. But, accidents happen... I've done it myself.
Tell me, just to be sure... is the Seq column a physical column in the SeqNumbers table? Also, what is the clustered index on that table. This isn't difficult nor slow, but I do need to know the particulars.
--Jeff Moden
Change is inevitable... Change for the better is not.