UFN_SITEID_MAPFROM_SOLICITCODEID

create function dbo.UFN_SITEID_MAPFROM_SOLICITCODEID(@SOLICITCODEID uniqueidentifier)  
returns @SITES table (SITEID uniqueidentifier)
as
begin

    insert into @SITES(
        SITEID
    )
    select SITEID 
    from dbo.SOLICITCODE 
    where ID=@SOLICITCODEID;            

    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