Guest User

Untitled

a guest
Jan 19th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. declare @coordinates table(latitude decimal(12,9), longitude decimal(12,9))
  2. insert into @coordinates select latitude, longitude from loc.locations where place_name IN ('Delhi', 'Mumbai')
  3.  
  4. select * from @coordinates
  5.  
  6. latitude longitude
  7. 28.666670000 77.216670000
  8. 19.014410000 72.847940000
Add Comment
Please, Sign In to add comment