2

Please login or register to vote for this query.

(click on this box to dismiss)

answers by specified user(s) that "should" have votes

Q&A for community managers, administrators, and moderators

select 
  RANK ( ) OVER ( partition by owneruserid ORDER BY case when acceptedanswerid is null then 0 else 1 end desc,
  len(body) desc ) as rnk,
  owneruserid as [User Link],
  id as [Post Link],
  acceptedanswerid,
  case when acceptedanswerid is null then 0 else 1 end as accepted, 
  format(creationdate,'yyyy-MM-dd') as answered,
  len(body) as length
into #tmp
from posts
where posttypeid=2
and owneruserid in ( ##UserID## )
and score <=0
order by  acceptedanswerid desc ,
  len(body) desc;
  
select * from #tmp --where rnk in (1,2,3)
order by  rnk, [User Link]

view current version

edited apr 30 19

created apr 28 19 ashleedawg