0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

EXEC dbo.sede_ineachdb N'

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

';

view current version

edited apr 11

created apr 11 Aaron Bertrand