I just stuck your statement (slightly re-arranged) into a CREATE TRIGGER statementNOTE:You need to change the JOIN Criteria to use whatever the Primary Key Columns are for [Member]if object_id('tr_U_Member') > 0 drop trigger tr_U_Membergocreate trigger tr_U_Member on dbo.Member AFTER UPDATEasbegin update m set m.secondarymarketgroup = l.[name] from inserted i inner join member m on m.<!!PRIMARMYKEY!!> = i.<!!m.PKcolumns!!> inner join location l on l.location_id = m.primarymarklocation_id where isNull(secondarymarketgroup, '') <> '' and prestnstatus in ('S','OH','H')Endgo
Be One with the OptimizerTG