TR_SALESORDERITEMTICKET_MARKASCONSTITUENT (Trigger)

        
                    CREATE trigger TR_SALESORDERITEMTICKET_MARKASCONSTITUENT 
                        on dbo.SALESORDERITEMTICKET 
                        after insert, update
                        not for replication
                    as begin
                        if update(ID)
                        begin
                            update dbo.CONSTITUENT
                                set ISCONSTITUENT = 1,
                                    CHANGEDBYID = inserted.CHANGEDBYID,
                                    DATECHANGED = GetDate()
                            from inserted
                                inner join dbo.SALESORDERITEM 
                                    on SALESORDERITEM.ID = inserted.ID                                
                                inner join dbo.SALESORDER 
                                    on SALESORDER.ID = SALESORDERITEM.SALESORDERID
                            where (SALESORDER.CONSTITUENTID = CONSTITUENT.ID) and 
                                    (CONSTITUENT.ISCONSTITUENT = 0) and 
                                    (dbo.UFN_CONSTITUENT_ISPATRON(CONSTITUENT.ID) = 1)
                        end
                    end