UFN_SYSTEMROLE_GETDASHBOARDLIST

            create function dbo.UFN_SYSTEMROLE_GETDASHBOARDLIST(@SYSTEMROLEID uniqueidentifier)
            /* Returns a table of IDs for all of the business processes that have been assigned to the given SYSTEMROLEID */
            returns table
            as return (
                select 
                    SRP.ID, 
                    SRP.DASHBOARDCATALOGID,
                    SRP.GRANTORDENY
                from 
                    SYSTEMROLEPERM_DASHBOARD as SRP
                where
                    SRP.SYSTEMROLEID=@SYSTEMROLEID
            )