I Have here may transaction notification, how can i exempt from this rule a "cancel doctatus"
thanks
--Duplicate Lab ID Reference Not Allowed
if @object_type = '17' and (@transaction_type= 'A' or @transaction_type= 'U')
begin
declare @LabID as varchar(200)
select @LabID = U_Lab_ID from RDR1 where docentry =@list_of_cols_val_tab_del
if 1 != (select count(docentry) from RDR1 with(nolock) where U_Lab_ID = @LabID)
begin
select @error = -3
select @error_message = 'Duplicate Lab ID Reference Not Allowed!'
end