USP_DATALIST_SYSTEMROLEFEATUREGROUPPERMISSIONS

CREATE procedure dbo.USP_DATALIST_SYSTEMROLEFEATUREGROUPPERMISSIONS(@SYSTEMROLEID uniqueidentifier)
as
    set nocount on;

    select
        SYSTEMROLEPERM_FEATUREGROUP.ID,
        SYSTEMROLEPERM_FEATUREGROUP.FEATUREGROUPCATALOGID,
        FEATUREGROUPCATALOG.UINAME NAME,
        FEATUREGROUPCATALOG.DESCRIPTION as DESCRIPTION
    from
        dbo.FEATUREGROUPCATALOG
        inner join dbo.SYSTEMROLEPERM_FEATUREGROUP
            on FEATUREGROUPCATALOG.ID = SYSTEMROLEPERM_FEATUREGROUP.FEATUREGROUPCATALOGID
    where
        SYSTEMROLEPERM_FEATUREGROUP.SYSTEMROLEID = @SYSTEMROLEID
        and SYSTEMROLEPERM_FEATUREGROUP.GRANTORDENY = 1
        and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
            (
                FEATUREGROUPCATALOG.SPECXML.query
                    (
                        'declare namespace common="bb_appfx_commontypes";
                        /*/common:InstalledProductList'
                    )
            )
    order by
        FEATUREGROUPCATALOG.UINAME;