1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

select 
  Id as [Post Link],
  Score,
  ViewCount,
  round(convert(decimal,ViewCount)/2500,2) as [% Notable],
  round(convert(decimal,ViewCount)/10000,2) as [% Famous],
  Case when AcceptedAnswerId is null then 'No' else 'Yes' end as AcceptedAnswer
from posts where OwnerUserId = ##UserId## and PostTypeId = 1

order by ViewCount Desc

view current version

edited may 28 13

created may 28 13 Steve Konves