1

Please login or register to vote for this query.

(click on this box to dismiss)

Total views, views per day and score per question.

Q&A for linguists, etymologists, and serious English language enthusiasts

-- How many views your questions received?
-- Total views, views per day and score per question.
SELECT 
  ViewCount, 
  convert(decimal(10,2), 
    convert(decimal(10,2), ViewCount) / 
    datediff(day, CreationDate, GETUTCDATE())) as [Views per day], 
  Score, 
  Id as [Post Link] 
FROM Posts
WHERE PostTypeId = 1 and OwnerUserId = ##UserId##
ORDER BY ViewCount DESC

fork query

created feb 23 11 kadosh76