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