USP_DATALIST_SYSTEMROLEATTRIBUTECATEGORYPERMS

                CREATE procedure dbo.USP_DATALIST_SYSTEMROLEATTRIBUTECATEGORYPERMS 

                @SYSTEMROLEID uniqueidentifier

                as

                    select 
                        AC.ID,
                        cast(AC.ID as nvarchar(36)) + cast(@SYSTEMROLEID as nvarchar(36)) as ATTRIBUTECATEGORYIDANDROLEID,
                        case when SRP.ID is null then '' else 'RES:padlock' end as [IMAGEKEY],
                        case when SRP.ID is null then 'Grant' else 'Deny' end,
                        AC.NAME as ATTRIBUTECATEGORY, 
                        RT.NAME as RECORDTYPE    

                    from 
                        dbo.ATTRIBUTECATEGORY as AC 
                    left join dbo.ATTRIBUTERECORDTYPE as ART on
                        ART.ID = AC.ATTRIBUTERECORDTYPEID
                    left join dbo.RECORDTYPE as RT on
                        RT.ID = ART.RECORDTYPEID 
                    left join dbo.SYSTEMROLEPERM_ATTRIBUTECATEGORY as SRP on
                        SRP.ATTRIBUTECATEGORYID = AC.ID and
                        SRP.SYSTEMROLEID=@SYSTEMROLEID 


                    order by AC.NAME