0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

SELECT 'http://http://stackoverflow.com/questions/' +  CONVERT(varchar,P.id)
FROM Posts P
INNER JOIN Comments C ON P.Id = C.PostId
WHERE closedDate IS NULL AND
P.CreationDate >= convert(datetime, '01/05/2012', 103) AND P.CreationDate <= convert(datetime, '01/06/2012', 103)   
AND LOWER(C.Text) LIKE '%peanut butter%'

fork query

edited sep 4 14 anonymous

created jul 1 12 Jeremy Thompson