UFN_CHARITYCLAIMREFERENCENUMBER_ONEDEFAULTENTRY

Returns true if there are zero or one default (no site) entries in the charity claim reference number table.

Return

Return Type
bit

Definition

Copy



            CREATE function dbo.UFN_CHARITYCLAIMREFERENCENUMBER_ONEDEFAULTENTRY()
            returns bit
            with execute as caller
            as begin
                declare @COUNT int;

                select @COUNT = count(ID)
                from dbo.CHARITYCLAIMREFERENCENUMBER 
                where not exists (    select 1 
                                    from dbo.CHARITYCLAIMREFERENCENUMBERSITE 
                                    where CHARITYCLAIMREFERENCENUMBERSITE.CHARITYCLAIMREFERENCENUMBERID = CHARITYCLAIMREFERENCENUMBER.ID)

                if @COUNT > 1 
                    return 0;

                return 1;
            end