SQL Server 2000: Generate Row Numbers

http://support.microsoft.com/default.aspx?scid=kb;en-us;186133