0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

EXEC dbo.sede_ineachdb N'

 SELECT Site = [$long name$],
        Question = CONCAT
        (
          [$site url$],
          ''/q/'',
          p.Id,
          ''|'',
          p.Title
        ),
        p.ViewCount, 
        p.Score, 
        p.CreationDate
   FROM Posts AS p 
  INNER JOIN Users AS u
     ON p.OwnerUserId = u.Id
  WHERE p.PostTypeId = 1 
    AND u.AccountId = ##AccountID:int##
 
 ';

fork query

created apr 16 Aaron Bertrand