0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs

declare @UserId integer = ##UserId##;

with
Top40Tag as (
select top 40 
         tagid
       , count(1) tagPostCount 
       , row_number() over (order by count(1) desc) tagRank
  from PostTags pt 
 group by tagid 
 order by count(1) desc
)
select   score
       , parentid
  from Posts p
 where CommunityOwnedDate is null  -- Not community wiki
   and PostTypeID = 2              -- Answers
   and OwnerUserID = @UserId    -- By the specified user

view current version

edited aug 8 20

created aug 8 20 jachguate