UFN_VALID_BASICGL_INSTALLED

      CREATE function dbo.UFN_VALID_BASICGL_INSTALLED()
      returns bit
      with execute as caller
      as begin
        declare @retval bit = 0
         /*
           Checking the tables is slightly less accurate because it only checks that 
           the product is installed and does not validate the product;
           however it is called so frequently that hitting the CLR routine is too expensive.
         */
          --if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('0E85C527-E6E9-4C5F-A8E8-105FD0E18FE7') = 1 and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('8D162D9F-D8E6-47D2-AA49-22BA137AAA48') = 0

         if exists(select ID from dbo.INSTALLEDPRODUCTLIST where ID = '0E85C527-E6E9-4C5F-A8E8-105FD0E18FE7')
            and not exists(select ID from dbo.INSTALLEDPRODUCTLIST where ID = '8D162D9F-D8E6-47D2-AA49-22BA137AAA48') 
              set @retval = 1;

        return @retval
      end