Error with TSQL code - SQL Server Forums

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

SQL Server 2008 Forums

Transact-SQL (2008)

Error with TSQL code

Author

Topic

abenitez77
Yak Posting Veteran

53 Posts

Posted - 2010-05-03 : 12:56:37

I am getting this error below when running my insert command. I am using sql server 2008

error:
Msg 102, Level 15, State 1, Line 19
Incorrect syntax near ')'.

Code:
Insert Into dbo.CMS_NewVnd_Master(
[Site_NBR], [AuditCode], [AuditDesc], [PRGIndustryDesc],
[PRGSubIndustryDesc], [CorpClientDesc], [AuditStatus], [Client_Nbr],
[AuditYearDesc], [VendorCode], [VendorDesc], New_Vnd, New_Name,
GroupVendor, GroupType)
(Select [Site_NBR], [AuditCode], [AuditDesc], [PRGIndustryDesc],
[PRGSubIndustryDesc], [CorpClientDesc], [AuditStatus], [Client_Nbr],
[AuditYearDesc], [VendorCode], [VendorDesc], New_Vnd, New_Name,
'Blackhawk Network', 'GiftCard'
From (Select * from dbo.tblv_Claims_2006AndGreater As CL2006
Where Not Exists(Select 1 From dbo.CMS_NewVnd_Master AS cnv
Where cnv.Site_Nbr = CL2006.Site_Nbr AND
cnv.Client_Nbr = CL2006.Client_Nbr AND
cnv.VendorCode = CL2006.VendorCode AND
(cl2006.VendorDesc Like 'Blackhawk Net%' OR cl2006.VendorDesc Like 'Blackhawk Mark%' OR
cl2006.VendorDesc Like 'BLACKHAWK MRKTG%')
)
)
)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-03 : 13:08:05

remove the last ) and try

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-05-03 : 13:22:08

You also need to alias the derived table

Insert Into dbo.CMS_NewVnd_Master(
[Site_NBR], [AuditCode], [AuditDesc], [PRGIndustryDesc], 
[PRGSubIndustryDesc], [CorpClientDesc], [AuditStatus], [Client_Nbr], 
[AuditYearDesc], [VendorCode], [VendorDesc], New_Vnd, New_Name, 
GroupVendor, GroupType) 
Select [Site_NBR], [AuditCode], [AuditDesc], [PRGIndustryDesc], 
[PRGSubIndustryDesc], [CorpClientDesc], [AuditStatus], [Client_Nbr], 
[AuditYearDesc], [VendorCode], [VendorDesc], New_Vnd, New_Name, 
'Blackhawk Network', 'GiftCard' 
From (Select * from dbo.tblv_Claims_2006AndGreater As CL2006 
Where Not Exists(Select 1 From dbo.CMS_NewVnd_Master AS cnv 
Where cnv.Site_Nbr = CL2006.Site_Nbr AND
cnv.Client_Nbr = CL2006.Client_Nbr AND 
cnv.VendorCode = CL2006.VendorCode AND
(cl2006.VendorDesc Like 'Blackhawk Net%' OR cl2006.VendorDesc Like 'Blackhawk Mark%' OR 
cl2006.VendorDesc Like 'BLACKHAWK MRKTG%')
)
)A

EDIT: Note that I removed the inital "(" from the SELECT as well.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources