Originally posted by : Carlo (raffic@tin.it)Hi,I've to number the records in a SQL query made with SQL Server 2000. I need a field containing the number of that specific row starting from 1 and ending with the number of records retrieved.Example1, Field1, Field2, Field2....., FieldN2, Field1, Field2, Field2....., FieldN3, Field1, Field2, Field2....., FieldN.....N, Field1, Field2, Field2....., FieldNWhere the first field will contain the row number.Can someone help me?Thanks