compare compound tag cleanup vs. score

0

Please login or register to vote for this query.

(click on this box to dismiss)

(approx how many points towards each tag badge - as of last Sunday's data update) .... See TAB#2 or totals.

Stack Overflow

Q&A for professional and enthusiast programmers

--user's vba + excel tags now.


--TAB#1 : Detail

select
  q.id as qID,
  --'site://u/'+cast(q.owneruserid as varchar)+'|'+left(displayname,20) as [Asked by],
  a.id as [Post Link],
  --a.owneruserid as aUserID,
  format(a.creationdate,'yyyy-MM-dd') as Answered,
  case when q.tags like '%<excel>%' then a.score else 0 end as [excel],
  case when q.tags like '%<vba>%' then a.score else 0 end as [vba],
  q.viewcount as qViews,
  a.score as aScore,
  q.Tags
into #temp
from posts q left outer join posts a 
  on q.id = a.parentid
--left outer join users u on u.id = q.owneruserid
where 
  a.owneruserid in (##UserID##)
  and (q.tags like '%excel%' or q.tags like '%vba>%')

select * from #temp

--TAB#2 : Totals
select
  sum(excel) as [excel],
  sum(vba) as [vba],
  sum(qViews) as [qViews],
  count(*) as [Count]
from #temp

Enter Parameters

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