SQL 2005 trigger Help

[anpbabaki]

Hello
I have 2 tables, Journal and Config

Journal holds fields AssetTag, TransferFrom, TransferTo
Config holds AssetTag, CustID

I cannot figure out how to create a trigger that when a record is inserted into Journal, the trigger finds the record in Config with the matching AssetTag and updates Config.CustID with the data from Journal.TransferTo

(AssetTag is unique in Config table)

[anpbabaki]

this is hwatt i came up with anyone see any flaws? it seems to work as i want it to

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




ALTER TRIGGER [monitorJournal]
ON [dbo].[Journal]
AFTER INSERT, UPDATE
AS
SET NOCOUNT ON;
IF (select AssetTag from inserted) <> '' AND (select transferTo from Inserted) <> '' AND (select transferToCustType from Inserted) <> ''
BEGIN
UPDATE dbo.config
SET CustID = (select transferTo from inserted), CustType = (select TransferToCustType from inserted)
Where Asset_Tag = (select AssetTag from inserted)
END