Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @coordinates table(latitude decimal(12,9), longitude decimal(12,9))
- insert into @coordinates select latitude, longitude from loc.locations where place_name IN ('Delhi', 'Mumbai')
- select * from @coordinates
- latitude longitude
- 28.666670000 77.216670000
- 19.014410000 72.847940000
Add Comment
Please, Sign In to add comment