DECLARE @usrid int = ##UserID## SELECT COUNT(UserID) AS ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @usrid int = ##UserID##

SELECT COUNT(UserID) AS n, Name AS m FROM Badges 
        WHERE TagBased = 0 AND
        UserID <> @usrid GROUP BY Name

Enter Parameters

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