UFN_SITEID_MAPFROM_IMPORTFIXEDWIDTHFILETEMPLATE

            create function dbo.UFN_SITEID_MAPFROM_IMPORTFIXEDWIDTHFILETEMPLATE
      (
                @IMPORTFIXEDWIDTHFILETEMPLATEID uniqueidentifier
            ) 
            returns @SITES table (SITEID uniqueidentifier)
      as
      begin
        insert into 
          @SITES(SITEID)
        select 
          SITEID 
        from 
          dbo.IMPORTFIXEDWIDTHFILETEMPLATE 
        where 
          ID = @IMPORTFIXEDWIDTHFILETEMPLATEID;

        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