May 20th of '10 at 01:16 PM
From
JonWire
Currently proposed solution as posted by Sagi88:
CREATE TRIGGER [Invoice_DOCDATE] ON SOP10106 FOR INSERT AS
Update SOP10100
Set DOCDATE = SOP10106.USRDAT02
From SOP10100, SOP10106
Where SOP10100.SOPTYPE = SOP10106.SOPTYPE AND
SOP10100.SOPNUMBE = SOP10106.SOPNUMBE AND
SOP10106. SOPTYPE in (select SOPTYPE from inserted) and
SOP10106.SOPNUMBE in (select SOPNUMBE from inserted) and
SOP10106.SOPTYPE = 3