Live Traffic Feed

A visitor from Yekaterinburg viewed 'Vimal Vataliya' 5 days 14 hrs ago
A visitor from Voronezh viewed 'filter row datagrid with multiple column on keyup ' 22 days 18 hrs ago
A visitor from St petersburg viewed 'Vimal Vataliya' 24 days 7 hrs ago
A visitor from Boardman viewed 'Vimal Vataliya' 24 days 7 hrs ago
A visitor from Virginia viewed 'Vimal Vataliya' 24 days 7 hrs ago
A visitor from Washington viewed 'filter row datagrid with multiple column on keyup ' 24 days 14 hrs ago
A visitor from Gatchina viewed 'filter row datagrid with multiple column on keyup ' 26 days 2 hrs ago
A visitor from Yekaterinburg viewed 'Open Source cryptocurrency Exchanges | Vimal Vatal' 27 days 22 hrs ago
A visitor from Gatchina viewed 'Open Source cryptocurrency Exchanges | Vimal Vatal' 1 month ago
A visitor from Omsk viewed 'Open Source cryptocurrency Exchanges | Vimal Vatal' 1 month 4 days ago

Monday, August 8, 2016

Find all rows within 2 km area of your specific point using sql server 2008

1 comment
Create PROCEDURE [SearchViaLocation]      @Longitude nvarchar(50)='0'      ,@Latitude nvarchar(50)='0'      ,@Distance decimal(18,8)=2000---(2km)      AS BEGIN      -- SET NOCOUNT ON added to prevent extra result sets from      -- interfering with SELECT statements.      SET NOCOUNT ON;    DECLARE @CurrentLocation geography; SET @CurrentLocation  = geography::Point(@longitude,...
Read More