TR_CHARGELINEITEMRESPONSIBILITY_TOTALPERCHARGEIS100

                    create trigger TR_CHARGELINEITEMRESPONSIBILITY_TOTALPERCHARGEIS100
                        on dbo.CHARGELINEITEMRESPONSIBILITY 
                        for insert, update, delete 
                        not for replication as
                    begin
                        set nocount on;
                        begin try
                            if exists(
                                select CHARGELINEITEMRESPONSIBILITY.FINANCIALTRANSACTIONLINEITEMID
                                from dbo.CHARGELINEITEMRESPONSIBILITY
                                where (CHARGELINEITEMRESPONSIBILITY.FINANCIALTRANSACTIONLINEITEMID in (select FINANCIALTRANSACTIONLINEITEMID from INSERTED)) or 
                                      (CHARGELINEITEMRESPONSIBILITY.FINANCIALTRANSACTIONLINEITEMID in (select FINANCIALTRANSACTIONLINEITEMID from DELETED))
                                group by CHARGELINEITEMRESPONSIBILITY.FINANCIALTRANSACTIONLINEITEMID
                                having SUM(CHARGELINEITEMRESPONSIBILITY.PERCENTAGE) != 100
                                )
                                    raiserror('ERR_FINANCIALTRANSACTIONLINEITEMID_TOTALPERCHARGEIS100', 13,1);
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                        end catch
                    end