2

Please login or register to vote for this query.

(click on this box to dismiss)

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

Declare @Tags nvarchar(30)
Set @Tags='<##Tag##>'
Set @Tags = Lower(@Tags)
SELECT p.Id AS [Post Link], p.Score, p.ViewCount, p.OwnerUserId as [User Link], p.CreationDate
FROM Posts p
WHERE PostTypeId = 1
AND Tags = @Tags
AND ClosedDate is null
order by Score desc

fork query

edited sep 24 15

created sep 24 15 Ϻ.Λ.Ʀ.