T-SQL Import data in Microsoft SQL Server Management Studio using INSERT

Hello expert,
I work for a healthcare company so we have old tools, SSMS ver 9 and SQL Server 2005.
Have question open on a similar topic and will close that question if I can get an answer that works.
While I was waiting I figured I would try importing  the data into the table using the old fashion method: INSERT
The syntax was derived from
https://technet.microsoft.com/en-us/library/dd776381(v=sql.105).aspx
and this script was written

 USE TempData;
 GO
 INSERT INTO SFA.tempCrossInsurance
 VALUES (377332, 'City of Auburn', 'Injury Care', 1832030, 207120, '', 98, 'Maine',1269046021)

This works and inserts the values. But I need more than one row so following
the example this was tried

USE TempData;
 GO
 INSERT INTO SFA.tempCrossInsurance
 VALUES (377332, 'City of Auburn', 'Injury Care', 1832030, 207120, '', 98, 'Maine',1269046021),
(288461, 'Lepage Bakeries', 'Injury Care',      1347245, 207119,'', 104, 'Rhode Island', 1259048689)

This returns
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ','.

Not very meaningful. I think the comma in the message is the one at the  end of the first group of values.
Also tried stringing the values out into a single line and several other variations such
as removing the comma between the groups of values.

I have studied the example for some time
but I don't see a difference between my script and the example.

Any idea why it is complaining about the comma?

Thanks.

Allen in Dallas
LVL 1
Allen PittsBusiness analystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
that syntax wont work on older versions of sql server

INSERT INTO SFA.tempCrossInsurance
 SELECT 377332, 'City of Auburn', 'Injury Care', 1832030, 207120, '', 98, 'Maine',1269046021
UNION ALL
SELECT 288461, 'Lepage Bakeries', 'Injury Care',      1347245, 207119,'', 104, 'Rhode Island', 1259048689
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
arnoldCommented:
What format is the data in?
Bcp is a command available or use bulk insert
https://technet.microsoft.com/en-us/library/ms188365(v=sql.110).aspx

Look at a Dts to load/import the data.
0
Allen PittsBusiness analystAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
T-SQL

From novice to tech pro — start learning today.