Total reputation (networkwide) for a single user


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

-- result table, don't rename and keep the site column
create table #results (site nvarchar(250)
, reputation int, id int);

declare @sql nvarchar(max) = ''   -- holds build up sql string

-- build one biq union sql, for each db
select @sql = @sql 
+ iif( len(@sql) > 1 
     , 'union all'
     , 'insert into #results'
) +
-- here goes the per site query, fully qualify the database objects
select ''' + name + ''', reputation, id
from ' + quotename(name) + '.dbo.users
where accountid = ' + CAST(##AccountId:int## AS nvarchar) + ''
from sys.databases
where database_id > 5
-- AccountId: The global account ID of the user, which you can find in the URL of their network profile. Visit this link: to see your own ID.

--print @sql

-- execute it
exec (@sql)

-- show results
select *
from #results

drop table #results

Enter Parameters

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