USP_INSTALLEDPRODUCTS_PRODUCTIS

        create procedure [dbo].[USP_INSTALLEDPRODUCTS_PRODUCTIS]
        @PRODUCTCODE uniqueidentifier,
        @ISINSTALLED bit output
        with execute as caller
        as

        --pdg 4.30.2012 changed this to a non-clr implementation to optimize performance

        select @ISINSTALLED = dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS(@PRODUCTCODE);

        return 0;