SELECT COALESCE((SELECT 1

FROM sys.database_principals DPR

INNER JOIN sys.database_role_members Member ON DPR.principal_id = Member.role_principal_id

INNER JOIN sys.database_principals DPU ON member.member_principal_id = dpu.principal_id

WHERE DPR.NAME = 'MyRole'

AND dpu.NAME = ORIGINAL_LOGIN() ),0) as MyRole