.

0

Please login or register to vote for this query.

(click on this box to dismiss)

3D Printing Meta

Q&A for 3D printing enthusiasts

declare @sedeUpdated date = ( select min(create_date) from sys.tables )

select
  *
into #temp from comments
where 
  userid = ##UserID##
  and creationdate >= dateadd(d,-7,@sedeUpdated)
  and 
     ( text like '%![mcve]%' escape '!' 
    or text like '%![ask]%' escape '!'
    or text like '%![help/on-topic]%' escape '!' )
order by creationdate

select 
  t.*,
  p.creationdate,
  p.closeddate,
  p.deletiondate
from #temp t left outer join postswithdeleted p on t.postid=p.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results