Guest User

Untitled

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