TR_PDACCOUNTSEGMENTVALUE_DESCRIPTION_ISUNIQUE (Trigger)

                
        CREATE trigger dbo.TR_PDACCOUNTSEGMENTVALUE_DESCRIPTION_ISUNIQUE on PDACCOUNTSEGMENTVALUE for INSERT, UPDATE not for replication as
        begin
          set nocount on;
            declare @IsBasicGL Bit;
            declare @PDAccountStructureID uniqueidentifier;
            select top 1 @IsBasicGL = T2.ISBASICGL,@PDAccountStructureID = T1.PDACCOUNTSTRUCTUREID from inserted T1 join dbo.PDACCOUNTSTRUCTURE T2 on T1.PDACCOUNTSTRUCTUREID = T2.ID
            if @IsBasicGL = 0

              if exists(SELECT I.ID FROM INSERTED I WHERE I.DESCRIPTION IN (SELECT DESCRIPTION
                        FROM dbo.PDACCOUNTSEGMENTVALUE WHERE PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID = @PDAccountStructureID
            and PDACCOUNTSEGMENTVALUE.ID <> I.ID)              
              )
              BEGIN
                RAISERROR ('UIX_PDACCOUNTSEGMENTVALUE_PDACCOUNTSTRUCTUREID_DESCRIPTION', 16, 1)
                ROLLBACK
              END
        end