Team Metova

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

CREATE TABLE #MetovaUsers (Name nvarchar(100), StackOverflowUserId int)

INSERT INTO #MetovaUsers (Name, StackOverflowUserId)
SELECT 'Nick Griffith', 2792531
UNION SELECT 'Andrew Neal', 420015
UNION SELECT 'Jason Robinson', 291827

SELECT MU.Name, 
  SOU.Id AS [UserLink], SOU.Reputation AS StackOverflowRep,
  CRU.Id AS [UserLink], CRU.Reputation AS CodeReviewRep
FROM #MetovaUsers MU
  INNER JOIN StackOverflow.dbo.Users SOU ON SOU.Id = MU.StackOverflowUserId
  LEFT OUTER JOIN [StackExchange.CodeReview].dbo.Users CRU ON CRU.AccountId = SOU.AccountId

SELECT name
FROM master..sysdatabases

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results