22 May, 2009
0 Comments
0 categories
see: http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133
Example query
select
rank() over (
order by
sl.[Title],
sl.[Description],
sl.[Order]
) as rank,
sl.[Title],
sl.[Description], sl.[Order]
from
[ScoreList] sl
order by rank
Tags: SQL Server