Viewing post 1 (of 1 total)
use northwind
go
select
(select count(1) from customers cu where cu.CustomerId <= c.CustomerId)
as Counter,
* from customers c
order by CustomerId
May 7, 2004 at 9:30 am
#505678