USP_DATALIST_FEATUREGROUPSYSTEMROLE

create procedure dbo.USP_DATALIST_FEATUREGROUPSYSTEMROLE(@FEATUREGROUPCATALOGID uniqueidentifier)
as
    set nocount on;

    select SYSTEMROLE.ID,
           SYSTEMROLE.NAME,
           SYSTEMROLE.DESCRIPTION
    from dbo.SYSTEMROLE
    inner join dbo.SYSTEMROLEPERM_FEATUREGROUP on SYSTEMROLE.ID = SYSTEMROLEPERM_FEATUREGROUP.SYSTEMROLEID
    where SYSTEMROLEPERM_FEATUREGROUP.FEATUREGROUPCATALOGID = @FEATUREGROUPCATALOGID
    order by SYSTEMROLE.NAME;