public void GenerateExcel()
{
System.Data.DataTable dt = new
System.Data.DataTable();
dt.Columns.Add("AccountNo");
for (int i = 0; i < 10; i++)
{
string a = "00001234456" + i;
if (a.StartsWith("0"))
...
Friday, September 2, 2016
Monday, August 8, 2016
Find all rows within 2 km area of your specific point using sql server 2008
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,...