3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

DECLARE @tag1 AS NVARCHAR(60) = ##Tag1:string? ##;
DECLARE @tag2 AS NVARCHAR(60) = ##Tag2:string? ##;
DECLARE @tag3 AS NVARCHAR(60) = ##Tag3:string? ##;

DECLARE @username AS NVARCHAR(60) = ##DisplayName:string? ##;
DECLARE @userId AS INT = ##UserId:int?-1##;

WITH Questions AS (
  SELECT *
  FROM Posts
  WHERE PostTypeId = 1
    AND (@userId < 0 OR OwnerUserId = @userId)
    AND (@username = '' OR OwnerUserId IN (
        SELECT Id
        FROM Users
        WHERE DisplayName = RTRIM(LTRIM(@username))))
)

SELECT TOP ##Limit:int?100##
  Id [Post Link],
  Tags,
  Score,
  AnswerCount,
  CreationDate,
  ClosedDate
FROM Questions
WHERE
  (@tag1 = '' OR LOWER(Tags) LIKE '%<' + LOWER(RTRIM(LTRIM(@tag1))) + '>%')
  AND (@tag2 = '' OR LOWER(Tags) LIKE '%<' + LOWER(RTRIM(LTRIM(@tag2))) + '>%')
  AND (@tag3 = '' OR LOWER(Tags) LIKE '%<' + LOWER(RTRIM(LTRIM(@tag3))) + '>%')
ORDER BY CreationDate DESC

fork query

edited jul 11 16

created jul 11 16 Janos