Dynamically number rows in a SELECT T-SQL statement (SQL Server 2000)

I encountered some TSQL Select problem where I want my result set to have a “number” on the first column. If for example you have a simple select statement

USE Northwind
SELECT    CustomerID
,    CompanyName
FROM      Customers
ORDER BY  CustomerID

Read the full article…

2 Comments »

  1. Harry said

    Hi Francesco

    Many thanks for your blog. This was realy simple but very helpfull.

  2. FM said

    Great stuff.

RSS feed for comments on this post · TrackBack URI

Leave a Comment