USP_SYSTEMROLE_GETSITESECURITYINFORMATION

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

    select
        SR.[SITEID],
        case when S.[NAME] is null then '<none>' else S.[NAME] end as 'SITENAME',
        S.[DESCRIPTION],
        case when SR.[SITEID] is null then 0 else 1 end as 'HASSITEID',
        SR.SITESECURITYMODE
    from
        dbo.[SYSTEMROLE] SR
        left join dbo.[SITE] S on SR.[SITEID] = S.[ID]
    where
        SR.[ID] = @ID;