Q&A about the site for members of the workforce navigating the professional setting
DECLARE @SearchText VARCHAR(100) = ##SearchText:string## DECLARE @OnlyBeginning BIT = ##OnlyBeginning:int## DECLARE @After DATETIME = ##After:string## DECLARE @Before DATETIME = ##Before:string## SELECT TOP 100 Id, Id AS [Post Link], CreationDate, Body FROM Posts WHERE PostTypeId = 2 AND ( (@OnlyBeginning = 1 AND Body LIKE '<p>' + @SearchText + '%') OR (@OnlyBeginning = 0 AND Body LIKE '%' + @SearchText + '%') ) AND (CreationDate >= @After) AND (CreationDate <= @Before) ORDER BY CreationDate DESC