UFN_SITEID_MAPFROM_ADHOCQUERYID

            create function dbo.UFN_SITEID_MAPFROM_ADHOCQUERYID
            (
                @ADHOCQUERYID uniqueidentifier
            )
            returns @SITES table (SITEID uniqueidentifier)
            as
            begin
                insert into @SITES(SITEID)
                    select ADHOCQUERY.SITEID from dbo.ADHOCQUERY where ID = @ADHOCQUERYID;

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