Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
DECLARE @BadgeName nvarchar(255) = '##BadgeName##' DECLARE @BadgeType int = ##BadgeType## -- 1: Gold, 2: Silver, 3: Bronze DECLARE @UserId int = ##UserId## SELECT Users.DisplayName, Users.Id, DATEDIFF(day, Users.CreationDate, Badges.Date) AS Days FROM Badges INNER JOIN Users ON Users.Id = Badges.UserId WHERE Badges.Class = @BadgeType AND Badges.TagBased = 1 -- for true AND Badges.Name = @BadgeName ORDER BY Days Asc