UFN_SITEID_MAPFROM_CONSTITUENTSOLICITCODEID

create function dbo.UFN_SITEID_MAPFROM_CONSTITUENTSOLICITCODEID(@CONSTITUENTSOLICITCODEID uniqueidentifier) 
returns @SITES table (SITEID uniqueidentifier)
as
begin

    insert into @SITES(
        SITEID
    )
    select SOLICITCODE.SITEID 
    from dbo.CONSTITUENTSOLICITCODE
        inner join dbo.SOLICITCODE on CONSTITUENTSOLICITCODE.SOLICITCODEID = SOLICITCODE.ID
    where CONSTITUENTSOLICITCODE.ID = @CONSTITUENTSOLICITCODEID;                

    if (select count(SITEID) from @SITES) = 0 --If no site has been assigned, then the address validation is unsecured and available to all sites.

    begin
        insert into @SITES(SITEID) values (null);
        insert into @SITES(SITEID) select ID from dbo.SITE;
    end

    return;
end