UFN_SITEID_MAPFROM_IMPORTDELIMITEDFILETEMPLATE

            create function dbo.UFN_SITEID_MAPFROM_IMPORTDELIMITEDFILETEMPLATE
      (
                @IMPORTFILETEMPLATEID uniqueidentifier
            ) 
            returns @SITES table (SITEID uniqueidentifier)
      as
      begin
        insert into @SITES(SITEID)
        select SITEID from dbo.IMPORTFILETEMPLATE where ID = @IMPORTFILETEMPLATEID;

        if (select count(SITEID) from @SITES) = 0 --If no site has been assigned, then the import source 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