By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,873 Members | 1,040 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,873 IT Pros & Developers. It's quick & easy.

2005 Trigger Error

P: 1
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_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[trig_OnInsert] ON [dbo].[tbl_ShipExport_UPS]
FOR INSERT
AS
UPDATE tbl_ShippingInfo

SET ship_TrackingNumber = b.ups_TrackingNumber
FROM tbl_ShippingInfo AS A, tbl_ShipExport_UPS AS B
WHERE a.ship_OrderNumber = b.ups_OrderNumber AND a.ship_Sequence = b.ups_Sequence
Oct 4 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.