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

select, 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
	usr.issqlrole = 1 
	and musr.issqlrole = 1
	and = 'clerks'