UFN_RELATIONSHIP_ISINDIVIDUALTOSTUDENT

create function dbo.UFN_RELATIONSHIP_ISINDIVIDUALTOSTUDENT
(
    @RELATIONSHIPCONSTITUENTID uniqueidentifier,
    @RECIPROCALCONSTITUENTID uniqueidentifier
)
returns bit
as begin
    declare @ISORGANIZATION bit;
    declare @ISGROUP bit;
    declare @RECIPROCALISORGANIZATION bit;
    declare @RECIPROCALISGROUP bit;

    select 
        @RECIPROCALISORGANIZATION = ISORGANIZATION,
        @RECIPROCALISGROUP = ISGROUP
    from 
        dbo.CONSTITUENT 
    where 
        ID = @RECIPROCALCONSTITUENTID;

    if @RECIPROCALISORGANIZATION = 0 and @RECIPROCALISGROUP = 0 and dbo.UFN_CONSTITUENT_ISSTUDENT(@RECIPROCALCONSTITUENTID) = 1            
        begin
            select 
                @ISORGANIZATION = ISORGANIZATION,
                @ISGROUP = ISGROUP
            from 
                dbo.CONSTITUENT 
            where 
                ID = @RELATIONSHIPCONSTITUENTID;

            if @ISORGANIZATION = 0 and @ISGROUP = 0 and dbo.UFN_CONSTITUENT_ISSTUDENT(@RELATIONSHIPCONSTITUENTID) = 0
                return 1;
            else
                return 0;
        end
    else
        return 0;

    return 0;

end