0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select
  len(p.Body) as Length, 
  p.Id as PostId, 
  p.Score
from
  dbo.Posts as p with (nolock)
where
  p.OwnerUserId = '##UserId##' and
  p.PostTypeId in (1, 2) and
  p.CreationDate >= '##asOf##'
order by
  1 desc

fork query

edited dec 23 12

created dec 12 12 casperOne