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 2005 Forums
 Transact-SQL (2005)
 SQL error

Author  Topic 

Mondeo
Constraint Violating Yak Guru

287 Posts

Posted - 2010-08-10 : 11:11:33
Hi,

Can anyone see the problem with the code below, i'm getting the error: Incorrect syntax near ']'.

Thanks


INSERT INTO tblIntermateGrid_Genus (VehicleRef, Type, CapID, Manufacturer, Model, Derivative, AdditionalFreeText, Created, Updated, Details, Notes, Dealer, Discount, DealerContribution, DeliveryCharge, RegisteredStatus, RegistrationDate, MustBeOrderedBy, MustBeDeliveredBy, source, vrb, approxleadtime, multipledeals, [2year10knotmaintainedch], [2year20knotmaintainedch], [2year30knotmaintainedch], [3year10knotmaintainedch], [3year20knotmaintainedch], [3year30knotmaintainedch], [2year10kmaintainedch], [2year20kmaintainedch], [2year30kmaintainedch], [3year10kmaintainedch], [3year20kmaintainedch], [3year30kmaintainedch], [2year10knotmaintainedpch], [2year20knotmaintainedpch], [2year30knotmaintainedpch], [3year10knotmaintainedpch], [3year20knotmaintainedpch], [3year30knotmaintainedpch], [2year10kmaintainedpch], [2year20kmaintainedpch], [2year30kmaintainedpch], [3year10kmaintainedpch], [3year20kmaintainedpch], [3year30kmaintainedpch], [2year10knotmaintainedpchexvat], [2year20knotmaintainedpchexvat], [2year30knotmaintainedpchexvat], [3year10knotmaintainedpchexvat], [3year20knotmaintainedpchexvat], [3year30knotmaintainedpchexvat], [2year10kmaintainedpchexvat], [2year20kmaintainedpchexvat], [2year30kmaintainedpchexvat], [3year10kmaintainedpchexvat], [3year20kmaintainedpchexvat], [3year30kmaintainedpchexvat]) VALUES (@VehicleRef, @Type, @CapID, @Manufacturer, @Model, @Derivative, @AdditionalFreeText, @Created, @Updated, @Details, @Notes, @Dealer, @Discount, @DealerContribution, @DeliveryCharge, @RegisteredStatus, @RegistrationDate, @MustBeOrderedBy, @MustBeDeliveredBy, @source, @vrb, @approxleadtime, @multipledeals,@2year10knotmaintainedch,@2year20knotmaintainedch,@2year30knotmaintainedch,@3year10knotmaintainedch, @3year20knotmaintainedch,@3year30knotmaintainedch,@2year10kmaintainedch,@2year20kmaintainedch,@2year30kmaintainedch,@3year10kmaintainedch, @3year20kmaintainedch,@3year30kmaintainedch,@2year10knotmaintainedpch,@2year20knotmaintainedpch,@2year30knotmaintainedpch,@3year10knotmaintainedpch, @3year20knotmaintainedpch,@3year30knotmaintainedpch],@2year10kmaintainedpch,@2year20kmaintainedpch,@2year30kmaintainedpch,@3year10kmaintainedpch, @3year20kmaintainedpch,@3year30kmaintainedpch,@2year10knotmaintainedpchexvat,@2year20knotmaintainedpchexvat,@2year30knotmaintainedpchexvat, @3year10knotmaintainedpchexvat,@3year20knotmaintainedpchexvat,@3year30knotmaintainedpchexvat,@2year10kmaintainedpchexvat,@2year20kmaintainedpchexvat, @2year30kmaintainedpchexvat,@3year10kmaintainedpchexvat,@3year20kmaintainedpchexvat,@3year30kmaintainedpchexvat)

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-08-10 : 11:44:19
YOu have a "]" for the variable @3year30knotmaintainedpch]
Go to Top of Page
   

- Advertisement -