Alternative to 740847

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

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##;

';

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results