Guest User

Untitled

a guest
Apr 23rd, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. Longitude Latitude Range Address
  2.  
  3.  
  4. 72.03092000 33.28729000 50 abcd
  5.  
  6. id Co_Lat Co_GLng
  7.  
  8. 8450 72.03092011 33.28729005
  9. 8451 73.03099001 32.28729901
  10.  
  11. id Co_Lat Co_GLng Address
  12.  
  13. 8450 72.03092011 33.28729005 abcd
  14. 8451 73.03099001 32.28729901 73.03099001,32.28729901
  15.  
  16. SELECT
  17. CT.Id,
  18. CT.Co_Lat,
  19. CT.Co_GLng,
  20. [Address] = COALESCE(AD.[Address],CT.Co_Lat+','+CT.Co_GLng,'')
  21. FROM Coordinate_Table CT
  22. LEFT JOIN Address_Table AD
  23. ON CT.Co_Lat BETWEEN AD.Longitude+0.00000005 AND AD.Longitude-0.00000005
  24. AND CT.Co_GLng BETWEEN AD.Latitude+0.00000005 AND AD.Latitude-0.00000005
Add Comment
Please, Sign In to add comment