USP_SIMPLEDATALIST_BATCHCATEGORY

CREATE procedure dbo.USP_SIMPLEDATALIST_BATCHCATEGORY
as begin
    select DISTINCT CATEGORY as VALUE
    from dbo.BATCHTYPECATALOG
    where
        1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
        (
            BATCHTYPECATALOG.SPECXML.query
                (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
        )
    order by VALUE
end