USP_DATALIST_APPLICATIONUSERFEATUREGROUPS

create procedure dbo.USP_DATALIST_APPLICATIONUSERFEATUREGROUPS(@APPUSERID uniqueidentifier)
as
    set nocount on;

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