CREATE TRIGGER dbo.trgUpdateFlag ON MyDB.dbo.SourceTable AFTER UPDATE
AS

UPDATE		t
SET		t.RecordUpdateFlag = GETDATE(),
		t.RecordUpdateType = 'U'
FROM		SourceTable AS t
INNER JOIN	inserted AS i ON i.PkCol = t.PkCol

INSERT		MyDB.dbo.xSourceTable
		(
			Col1,
			Col2,
			... ,
			RecordUpdateFlag,
			RecordUpdateType,
			...
		)
SELECT		Col1,
		Col2,
		... ,
		GETDATE() AS RecordUpdateFlag,
		'U' AS RecordUpdateType,
		...
FROM		inserted

quote:

---

Originally posted by RB2K

CREATE TRIGGER [dbo].[Update_Flag] 
ON [MYDB].[dbo].[SOURCETABLE]
BEFORE UPDATE 
AS 
Update [SOURCETABLE]
Set RecordUpdateFlag = 'X'

Update [SOURCETABLE]
Set RecordUpdateType='U' -- For Record Update

Insert into MYDB.dbo.[xSOURCETABLE]
Select * from [SOURCETABLE]
where RecordUpdateFlag = 'X' 
and RecordUpdateType='U'

Update [SOURCETABLE]
Set RecordUpdateFlag= GetDate()

Update [xSOURCETABLE]
Set RecordUpdateFlag= GetDate()

---