Team Metova


Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

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

  SOU.Id AS [User Link], 
  SOU.Reputation AS StackOverflowRep,
  '' + CAST(CRU.Id as nvarchar) + '|' + CRU.DisplayName, 
  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

Enter Parameters

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