USP_SYSTEMROLE_GETCONSTITUENTSECURITYINFORMATION

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

    select
        CSR.[ID],
        case when CSR.[NAME] is null then '<none>' else CSR.[NAME] end as 'CONSTIT_SECURITY_RINGFENCENAME',
        CSR.[DESCRIPTION],
        case when CSR.[ID] is null then 0 else 1 end as 'HASRINGFENCEID',
        RECORDSECURITYMODE
    from
        dbo.[SYSTEMROLE] SR
        left join dbo.[SYSTEMROLE_CONSTIT_SECURITY_ATTRIBUTE] SRCSR on SRCSR.[ID] = SR.[ID]
        left join dbo.[CONSTIT_SECURITY_ATTRIBUTE] CSR on CSR.[ID] = SRCSR.[CONSTIT_SECURITY_ATTRIBUTEID]
    where
        SR.[ID] = @ID;