USP_SIMPLEDATALIST_FUNCTIONALAREA

CREATE procedure dbo.USP_SIMPLEDATALIST_FUNCTIONALAREA
as begin
    select ID as VALUE, 
           [NAME] as LABEL,
           '' AS DESCRIPTION,
           FUNCTIONALAREASPECXML.value('declare namespace bbfa="bb_appfx_functionalarea";
                    /bbfa:FunctionalAreaSpec[1]/@ImageKey', 'nvarchar(500)') as IMAGEKEY
    from dbo.FUNCTIONALAREACATALOG 
    where
        1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
        (
            FUNCTIONALAREACATALOG.FUNCTIONALAREASPECXML.query
                (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
        )
    order by NAME
end