Msg 156, Level 15, State 1, Line 22

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Msg 156, Level 15, State 1, Line 22

Author

Topic

tlouvierre
Starting Member

8 Posts

Posted - 2010-09-01 : 21:00:59

Hello to All,
I have this table that is giving me a hard time. I have been wrestling with how to use SQL server 2008 and I have a simple program to do. This program is about employee statistics and for the life of me I can not get it to run. In the enclosed statement I have included the code and the error messages. Can someone help me?

Create Table [KudlerFineFoods_EmployeeID_Table1] ([EmployeeID_SerialNumber] [varchar(max),]);
Create Table POS410
(POS_410 Number constraint POS_410_pk primary key,
POS410 Varchar2(75) not null,
POS410_SQL CLOB,
POS410_SerialNumber Varchar2(50),
Employment_cat Number references EMP_CATS,
Required Char,
Equipment Varchar2(50),
Active Char);
INSERT INTO [KudlerFineFoods_EmployeeID_Table1] ([EmployeeID_SerialNumber])
VALUES([EmployeeID,1]), ([Last Name,2]),([First Name,3]), ([Address,4]), ([City,5]), ([State,6]), ([Telephone Area Code,7]), ([Telephone Number,8])
INSERT INTO [KudlerFineFoods_EmployeeID_Table1]
VALUES (1,'Edelman','Glenn','175 Bishops Lane','La Jolla','California','619','555-0199','Cashier','10-7-2003','11.25','male','unknown'),
(2,'McMullen','Eric','763 Church St.','Lemon Grove','California','619','555-0135','Bagger','12-1-2004','6.75','male','unknown'),
(3,'Raj','Slentz','123 Torrey Dr.','North Clairmont','California','619','555-0123','Store Manager','6-1-2002','50,000','male','unknown'),
(4,'Erin','Brown','2045 Parkway Apt. 2B','Encinitas','California','760','555-0000','Bagger','6-1-2004','7.25','female','unknown'),
(5,'Donald','Carpenter','927 Second St.','Encinitas','California','619','555-0154','Stocker','1-1-2005','7.75','male','unknown'),
(6,'David','Esquivez','10983 N. Coast Hwy Apt 902','Encinitas','California','760','555-0108','Asst. Butcher & Seafood','7-25-,03','9.25','male','unknown'),
(7,'Nancy','Sharp','10793 Montecino Rd.','Ramona','California','858','555-0135','Cashier','1-1-2004','10.50','female','unknown'),
INSERT INTO POS410 (SERIALNUMBER)VALUES (COALESCE((SELECT MAX(SERIALNUMBER)
FROM [KudlerFineFoods_EmployeeID_Table1]), 0)+1, ‘John’, ‘Smith’, 999.99)

Msg 156, Level 15, State 1, Line 22
Incorrect syntax near the keyword 'INSERT'.
Msg 102, Level 15, State 1, Line 23
Incorrect syntax near '‘'.

Tiffany D. Louvierre-Ramirez

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2010-09-01 : 21:55:16

how many columns does table 'KudlerFineFoods_EmployeeID_Table1' have ?? And how many values per row are you inserting?