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