Stack Exchange
log in help

Me

0

Please login or register to vote for this query.

(click on this box to dismiss)

This current version includes redundant stuff because of previous export processes that allowed just the relevant databases to be included. These are easily skipped or deleted from the Text-only results when you past the results into a new query, such as http://data.stackexchange.com/stackoverflow/query/69701/emailhash-comparison. Note the December 2012 export includes some EmailHashes that are case sensitive and some that are case insensitive, so I COLLATED all comparisons rather than working out which is which.

Open Data

Q&A for developers and researchers interested in open data

Select 'Select ''' + Replace([Name],'','') + ''' As [DatabaseName], '
+ 'Count(*) As [Count] '
+ 'From [' + [Name] + ']..Users fu Join Users u ON fu.DisplayName=u.DisplayName COLLATE SQL_Latin1_General_CP1_CI_AS'
+ ' Where fu.DisplayName="Manishearth"<>'''' COLLATE SQL_Latin1_General_CP1_CI_AS'
+ ' UNION ALL '
From sys.Databases
Where Name Like '%'
fork query

Enter Parameters

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