3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

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 = @username))
)

SELECT TOP 10 Id [Post Link], Tags FROM Questions
WHERE Tags LIKE '%optimization%'

view current version

edited jul 11 16

created jul 11 16 Janos