List of Users in a given location. Case Sensitive
Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
-- List of Users in a given location -- Case Sensitive SELECT Top ##Top## ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, Location, --CreationDate, LastAccessDate, UpVotes, DownVotes FROM Users where ( location like '%##Location##%' --For the abbreviation right side match, lead with a space -- Enter dummy if not required or location like '%##AbbreviationRightSide##' ) -- exclusions and not ( -- Enter dummy if not required location LIKE '%##Exclusion##%' or location LIKE '%##ExclusionRightSide##' or location LIKE '%Quindio%' ) AND reputation > 2000 order by location asc -- to pick out incorrect results