select *
from Badges b with (nolock)
where
    b.Name = 'linq'
and b.UserId = 22656

WITH linqbadges
     AS (SELECT Rank() OVER (PARTITION BY b.userid ORDER BY b.DATE) rn,
                b.userid,
                b.DATE
         FROM   badges b
         WHERE  b.name = 'linq')
SELECT u.displayname,
       linqbadges.DATE AS date_earned,
       CASE rn
         WHEN 1 THEN 'bronze linq'
         WHEN 2 THEN 'silver linq'
         WHEN 3 THEN 'gold linq'
       END             AS badge
FROM   linqbadges
       INNER JOIN users u
         ON linqbadges.userid = u.id
ORDER BY
        displayname,
        date_earned