SELECT b.Id , b.UserId , b.Name , b.Date , b.Class , [Ba...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

SELECT  b.Id
            , b.UserId
            , b.Name
            , b.Date
            , b.Class
            , [Badge Class] = (
                CASE    WHEN class = 1 THEN 'Gold'
                        WHEN class = 2 THEN 'Silver'
                        WHEN class = 3 THEN 'Bronze'
                END
            )
            , [Is tag badge] = IIF (b.TagBased = 1, 'Yes', 'No')
    FROM    Badges b
    WHERE   b.UserId = ##UserId:INT##

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results