Sample Header Ad - 728x90

How to insert into TABLE Variable?

3 votes
2 answers
70465 views
I want to store 2 coordinate points (latitude, longitude) in a table variable. I have tried: declare @coordinates table(latitude1 decimal(12,9), longitude1 decimal(12,9), latitude2 decimal(12,9), longitude2 decimal(12,9)) select latitude, longitude into @coordinates from loc.locations where place_name IN ('Delhi', 'Mumbai') select @coordinates It's showing error: > Msg 102, Level 15, State 1, Line 2 > Incorrect syntax near '@coordinates'. The result of the select query: select latitude, longitude from loc.locations where place_name IN ('Delhi', 'Mumbai') is: latitude longitude 28.666670000 77.216670000 19.014410000 72.847940000 How can I store the values in table datatype? I ran the query SELECT @@VERSION and got the result: > Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Apr 29 2016 23:23:58 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows 10 Enterprise 6.3 (Build 16299: )
Asked by Gour Gopal (255 rep)
Jan 19, 2018, 08:29 AM
Last activity: Jan 19, 2018, 10:35 AM