UFN_GLACCOUNT_EXISTS

CREATE function dbo.UFN_GLACCOUNT_EXISTS()
returns bit
with execute as caller
as begin
  declare @retval bit = 0

 /*
   Checking the tables is 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