Roles Assigned to a Role.sql
/*
	List the roles that are assigned to a role
	
	Enter the role (usr.name='') you wish to see the assignments for.
*/

select musr.name, musr.uid 
from sys.sysusers as usr
	inner join (sys.sysmembers mbr
		inner join sys.sysusers musr 
		on mbr.memberuid =  musr.uid)
	on usr.uid = mbr.groupuid
where 
	usr.issqlrole = 1 
	and musr.issqlrole = 1
	and usr.name = 'clerks'