USP_DATALIST_SYSTEMROLES_NOGROUPS
Returns a list of all System roles
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SYSTEMROLES_NOGROUPS AS
--Used by the "System Roles" datalist
--Returns all system roles ordered by name
select SR.ID,
SR.NAME,
SR.DESCRIPTION,
(select COUNT(*) from dbo.SYSTEMROLEAPPUSER AS SRAU
where SRAU.SYSTEMROLEID=SR.ID) AS 'NUMUSERS'
from dbo.SYSTEMROLE AS SR
ORDER BY SR.NAME ASC