0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for biology researchers, academics, and students

DECLARE @tag VARCHAR(10) = '<' + ##Tag:string## + '>';
DECLARE @startdate DATETIME = '##StartDate##';


WITH [CTE] AS (
  SELECT * FROM Posts WHERE CHARINDEX(@tag, Tags)>0 AND CreationDate > @startdate
  UNION ALL
  SELECT Posts.* FROM Posts JOIN [CTE] on Posts.ParentId = [CTE].Id
)

SELECT * FROM [CTE] ORDER BY Id

fork query

edited oct 18 17

created oct 18 17 Vinay