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
|
Trigger Definition
