USP_SYSTEMROLE_GETGENERALINFORMATION

create procedure dbo.USP_SYSTEMROLE_GETGENERALINFORMATION
(
    @ID uniqueidentifier
)
as
    set nocount on;

    select
        SR.NAME,
        SR.DESCRIPTION,
        coalesce(PERMS.GRANTORDENY, 0) as 'CANCUSTOMIZEHOMEPAGE'
    from 
        dbo.SYSTEMROLE AS SR 
        left outer join dbo.SYSTEMROLEPERM_DATAFORMINSTANCE as PERMS on SR.ID = PERMS.SYSTEMROLEID 
            and PERMS.DATAFORMINSTANCECATALOGID = '691E1971-13B1-4947-AAD5-1D47103124F4'
    where
        SR.ID = @ID;