Generalist badge progress


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- but on a different site.

-- Generalist Progression
-- So I know what needs to be done

declare @temp table (id int identity(1,1), TagName char(128),TagCount int, score int);

with tags40 as (
select top 40 tagid, count(*) as TagCount from posttags group by tagid order by count(*) desc

answers as (
  select score, id, parentId from posts  -- find responses of questions
  where communityowneddate is null   -- which are non-comm-wiki
  and posttypeid = 2                 -- answers
  and owneruserid = ##UserId##       -- by you

insert @temp(TagName,TagCount, score) 
select t.TagName,min(f.TagCount), sum(a.score) as score from answers a
inner join posttags pt on pt.postid = a.parentId -- find tags of your answers
inner join tags40 f on f.tagid = pt.tagid        -- which are one of the top 40s
inner join tags t on f.tagid =
group by t.tagname
order by min(f.TagCount) desc

select id,TagName, TagCount, case when TagCount >= 200 then '' else '!' end, score, case when score >= 15 then '' else '!' end from @temp

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results