UFN_SITEID_MAPFROM_SMARTQUERYINSTANCEID

            create function dbo.UFN_SITEID_MAPFROM_SMARTQUERYINSTANCEID
            (
                @SMARTQUERYINSTANCEID uniqueidentifier
            )
            returns @SITES table (SITEID uniqueidentifier)
            as
            begin
                insert into @SITES(SITEID)
                    select SMARTQUERYINSTANCE.SITEID from dbo.SMARTQUERYINSTANCE where ID = @SMARTQUERYINSTANCEID;

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