Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
DECLARE @long1 decimal(5,2); DECLARE @lat1 decimal(5,2); DECLARE @rangeFactor decimal(7,6); SET @rangeFactor = 0.014457; SELECT @lat1 = LATITUDE, @long1 = LONGITUDE FROM dbo.zipcodes where zipcode = '" + Replace(rsC9__varZ2, "'", "''") + "'; SELECT DISTINCT(C.CommunityName), B.ABBR, B.Latitude, B.Longitude, B.zipcode, C.CommunityID, C.CommCity, C.CommState, C.CommZip, CommCode1 FROM dbo.zipcodes B inner join dbo.Communities C ON B.ZipCode = C.CommZip WHERE B.LATITUDE BETWEEN @lat1-(100 *@rangeFactor) and @lat1+(100 *@rangeFactor) AND B.LONGITUDE BETWEEN @long1-(100 *@rangeFactor) and @long1+(100 *@rangeFactor) AND dbo.getDistance(@lat1,@long1,B.latitude,B.longitude) <= 100 AND (PATINDEX('%" + Replace(rsC9__varS4, "'", "''") + "%', CommCode1) > 0) ORDER BY C.CommunityName ASC"
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.