How to generate Row_numbers in Sql Server 2000? - MSDN - Microsoft

in Sql Server 2005 we are using ... but I am expecting in Sql Server 2000 ... where counter.value

social.msdn.microsoft.com