1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

DECLARE @keyword AS NVARCHAR(60) = ##keyword:string? ##;
DECLARE @pauthor AS INT = ##PostAuthor:int?-1##

SELECT
  p.Id AS [Post Link],
  'site://q/' + Convert(VarChar(10), p.Id) + '#comment' +  Convert(VarChar(10), p.Id) + '_' + Convert(VarChar(10), c.Id) + '|' + c.Text AS [Comment],
  c.Score AS [Score],
  p.CreationDate AS [Post date],
  c.CreationDate AS [Comment date]
FROM Posts p
INNER JOIN Comments c
ON c.PostId = p.Id
WHERE
  p.OwnerUserId = @pauthor
  AND c.Text LIKE N'%' + @keyword + '%' COLLATE Latin1_General_100_CI_AI_SC_UTF8
ORDER BY c.CreationDate

fork query

edited nov 26 20 GNU.Supporter

created jul 31 14 Gilles