SQLTestUser (6/17/2013)

---

I have a column that has to be set with a certain value as A,B,C or D when a certain column has a value i.e. is not null. The columns are in various tables in the databases and the select is show below

select A.decription, B.Decsription,C.Description,D.Decription

from Audit A left join A.Id = B.ID

left join on B.Id =C.ID

left join on C.ID = D.ID

and the column X in Audit table has to be updated with A,B,C,D as when if there is value in A.description the value for X will be B, when B.Description has value the value on X will be C, when c.description is there the value for X will be D

how do i form a trigger that does this

thanks