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 @SQLCommand=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##;
';

fork query

edited apr 12 anonymous

created apr 11 Aaron Bertrand