UFN_CONSTITUENTRESTRICTIONOPTION_ISUNIQUE

            create function dbo.UFN_CONSTITUENTRESTRICTIONOPTION_ISUNIQUE
            (
                @CONSTITUENTID uniqueidentifier,
                @EVENTRESTRICTIONOPTIONID uniqueidentifier
            )
            returns bit
            as begin

                declare @ISUNIQUE bit = 0;
                declare @OPTIONCOUNT integer = 0;

                select 
                    @OPTIONCOUNT = count(ID)  
                from 
                    dbo.CONSTITUENTRESTRICTIONOPTION 
                where 
                    CONSTITUENTID = @CONSTITUENTID 
                    and
                    EVENTRESTRICTIONOPTIONID = @EVENTRESTRICTIONOPTIONID

                if @OPTIONCOUNT <= 1
                    set @ISUNIQUE = 1;

                return @ISUNIQUE
            end