USP_SIMPLEDATALIST_BBISBATCHTEMPLATELIST

CREATE procedure dbo.USP_SIMPLEDATALIST_BBISBATCHTEMPLATELIST as
    select 
    distinct BATCHTEMPLATE.ID as VALUE, BATCHTEMPLATE.NAME as LABEL 
    from 
    dbo.BATCHTEMPLATE 
      left join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    where 
      (BATCHTYPECATALOG.CATEGORY = 'NetCommunity' OR BATCHTYPECATALOG.CATEGORY = 'Blackbaud Internet Solutions') OR
      BATCHTYPECATALOG.ID = '196a2540-005a-4547-91a7-b301c464e28c'
      and BATCHTEMPLATE.CUSTOM = 0 
      and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
          (
              BATCHTYPECATALOG.SPECXML.query
                  (
                      'declare namespace common="bb_appfx_commontypes";
                      /*/common:InstalledProductList'
                  )
          )