TR_GLACCOUNT_PDACCOUNTSYSTEMID_ACCOUNTNUMBER_ISUNIQUE (Trigger)

                
            CREATE trigger dbo.TR_GLACCOUNT_PDACCOUNTSYSTEMID_ACCOUNTNUMBER_ISUNIQUE on GLACCOUNT for INSERT, UPDATE not for replication as
            begin
              set nocount on;
              declare @IsBasicGL Bit
              
              select  top 1 @IsBasicGL = ISBASICGL from inserted t1 join PDACCOUNTSYSTEM t2 on t1.PDACCOUNTSYSTEMID = t2.ID 
              if @IsBasicGL = 1
                  if exists(select  COUNT(ID) from GLACCOUNT where len(ACCOUNTNUMBER) > 0 group by PDACCOUNTSYSTEMID,ACCOUNTNUMBER having COUNT(ID) > 1
                  )
                  BEGIN
                    RAISERROR ('UIX_GLACCOUNT_PDACCOUNTSYSTEMID_ACCOUNTNUMBER', 16, 1)
                    ROLLBACK
                  END
            end