I'm trying to create a trigger on OTShipments where after a record is inserted, it populates a shipment table.
I get an error on: Line 13 [Batch Start Line 0] Incorrect syntax near ','.
This line: SET @MerchDescrip = MerchDescrip, @BillWeight = BillWeight, @TrackNo = TrackNo, @STCompany = STCompany, @STAdd1 = STAdd1,
@STZip = STZip, @STState = STState, @STCity = STCity, @Ref2 = Ref2, @Ref1 = Ref1
I keep staring at the SET statement and I don't see a syntax error. What am I missing?
Thanks!
CREATE TRIGGER dbo.OTInsertShipments
ON OTShipments
AFTER INSERT
AS
SELECT TrackNo, STCompany, STAdd1, STAdd2, STAdd3, STZip, STState, STCity, Ref2, Ref1, MerchDescrip, BillWeight
FROM OTShipments
DECLARE @MerchDescrip varchar(35), @BillWeight varchar(35), @TrackNo varchar(35), @STCompany varchar(35), @STAdd1 varchar(35),
@STZip varchar(35), @STState varchar(35), @STCiy varchar(35), @Ref2 varchar(35), @Ref1 varchar(35)
SET @MerchDescrip = MerchDescrip, @BillWeight = BillWeight, @TrackNo = TrackNo, @STCompany = STCompany, @STAdd1 = STAdd1,
@STZip = STZip, @STState = STState, @STCity = STCity, @Ref2 = Ref2, @Ref1 = Ref1
INSERT INTO Shipments
(Void, Carrier, MerchID, SFCompany, InvNo, PONo, BillTo, ShipperNo, TPShipperNo, ServiceType, NegRate, PubRate, TrackNo, TrackNoPkg,
ActWeight, Weight, BillWeight, STCompany, STAdd1, STCity, STState, STZip, MerchDescrip, ReturnService, Ref1, Ref2, Ref3, Ref4, Ref5)
VALUES
('N', 'OT', 'FREIGHT', 'WAREHOUSE',@Ref2,@Ref1, 'Third Party', '204389', '199480', 'Ground', 0, 0,@TrackNo,@TrackNo,
@BillWeight,@BillWeight,@BillWeight,@STCompany,@STAdd1,@STCiy,@STState,@STZip,@MerchDescrip, 'N',@Ref1,@Ref2,@Ref2,@Ref1,@MerchDescrip)