Cool Sql Tip, Auto Inc On Update

DECLARE @counter int
SET @counter = 0
UPDATE #tmp_Users
SET @counter = counter = @counter + 1

Please read the rest of the cool article:
http://haacked.com/archive/2004/02/28/sql-auto-increment.aspx