dbo.QER_TUOrgType

1    create   trigger QER_TUOrgType on OrgType  for UPDATE not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted) goto 
2start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')
3  if update (IsPersonAssignOnce) begin if exists (select top 1 1 from OrgType t join deleted d on t.UID_OrgType = d.UID_OrgType where t.IsPersonAssignOnce
4 = 1 and exists (select top 1 1 from PersonInBaseTree pib join BaseTree b on pib.UID_Org = b.UID_Org join OrgRoot r on b.UID_OrgRoot = r.UID_OrgRoot and
5 r.UID_OrgType = t.UID_OrgType group by pib.UID_Person having count(*) > 1 ) ) begin raiserror( '#LDS#IsPersonAssignOnce cannot be set, because at least one person is assigned to a role class in this role type more than once.|'
6, 18, 2) with nowait end end if update (IsPersonAssignOnce) begin if exists (select top 1 1 from OrgType t join deleted d on t.UID_OrgType = d.UID_OrgType
7 where t.IsPersonAssignOnce = 1 and exists (select top 1 1 from PersonInBaseTree pib join BaseTree b on pib.UID_Org = b.UID_Org where b.UID_OrgType = t.UID_OrgType
8 group by pib.UID_Person having count(*) > 1 ) ) begin raiserror( '#LDS#IsPersonAssignOnce cannot be set, because at least one person is assigned to roles in this role type more than once.|'
9, 18, 2) with nowait end end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
10