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

July 10, 2006 at 12:42 am · Filed under SQL

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

    November 13, 2007 @ 9:36 am

    Hi Francesco

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

  2. FM said

    December 10, 2007 @ 11:13 am

    Great stuff.

RSS feed for comments on this post

Comments are closed.