List users from by location

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

DECLARE @Location NVARCHAR(100) = '##Location##'

SELECT --TOP 30
  DisplayName As Name,
  ('http://stackoverflow.com/users/' + CAST(Id As VARCHAR) + '/' + REPLACE(Lower(DisplayName), ' ', '-')) As URI,
  Reputation,
  Views
FROM
  Users
WHERE
  Lower(Location) LIKE '%' + Lower(@Location) + '%'
ORDER BY Reputation DESC

Enter Parameters

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