Questions tagged only with [homework]

1

Please login or register to vote for this query.

(click on this box to dismiss)

Chemistry

Q&A for scientists, academics, teachers, and students in the field of chemistry

-- OpenQs: Include open questions? (Y/N)
-- ClosedQs: Include closed questions? (Y/N)
DECLARE @OpenQs nvarchar = ##OpenQs:string?Y##
DECLARE @ClosedQs nvarchar = ##ClosedQs:string?N##

SELECT q.Id as [Post Link], q.Score, q.Tags, q.ClosedDate, q.CreationDate

FROM Posts q

WHERE q.PostTypeId = 1 AND q.Tags = '<homework>' AND 
         (
           (q.ClosedDate IS NULL AND UPPER(@OpenQs) = 'Y')
         OR
           (q.ClosedDate IS NOT NULL AND UPPER(@ClosedQs) = 'Y')
         )

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results