USP_SIMPLEDATALIST_BATCHTEMPLATELIST

CREATE procedure dbo.USP_SIMPLEDATALIST_BATCHTEMPLATELIST(@CATEGORY nvarchar(100) = '') as
    select distinct BATCHTEMPLATE.ID as VALUE, BATCHTEMPLATE.NAME as LABEL 
    from dbo.BATCHTEMPLATE
    left join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    where 
    (@CATEGORY is null or len(@CATEGORY) = 0 or BATCHTYPECATALOG.CATEGORY = @CATEGORY)
    and BATCHTEMPLATE.CUSTOM = 0 
    and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
        (
            BATCHTYPECATALOG.SPECXML.query
                (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
        )
    order by BATCHTEMPLATE.NAME