Below is a trigger that was working in SQL 2003 but will not work in Server 2005. All the fields are the same.
Any help would be greatly appreciated.
Dan
USE [Distribution]
GO
/****** Object: Trigger [dbo].[trig_OnInsert] Script Date: 10/04/2007 08:03:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFI ER ON
GO
ALTER TRIGGER [dbo].[trig_OnInsert] ON [dbo].[tbl_ShipExport_ UPS]
FOR INSERT
AS
UPDATE tbl_ShippingInf o
SET ship_TrackingNu mber = b.ups_TrackingN umber
FROM tbl_ShippingInf o AS A, tbl_ShipExport_ UPS AS B
WHERE a.ship_OrderNum ber = b.ups_OrderNumb er AND a.ship_Sequence = b.ups_Sequence
Any help would be greatly appreciated.
Dan
USE [Distribution]
GO
/****** Object: Trigger [dbo].[trig_OnInsert] Script Date: 10/04/2007 08:03:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFI ER ON
GO
ALTER TRIGGER [dbo].[trig_OnInsert] ON [dbo].[tbl_ShipExport_ UPS]
FOR INSERT
AS
UPDATE tbl_ShippingInf o
SET ship_TrackingNu mber = b.ups_TrackingN umber
FROM tbl_ShippingInf o AS A, tbl_ShipExport_ UPS AS B
WHERE a.ship_OrderNum ber = b.ups_OrderNumb er AND a.ship_Sequence = b.ups_Sequence