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