UFN_DASHBOARD_GETSYSTEMROLEPERMISSIONSLIST

            create function dbo.UFN_DASHBOARD_GETSYSTEMROLEPERMISSIONSLIST(@DASHBOARDCATALOGID uniqueidentifier)
            /* Returns a table of IDs for all of the system roles that have permissions set for the given DASHBOARDCATALOGID */
            returns table
            as return (
                select 
                    SRP.ID, 
                    SR.NAME, 
                    SRP.SYSTEMROLEID, 
                    SRP.GRANTORDENY
                from 
                    dbo.SYSTEMROLE as SR 
                    left outer join dbo.SYSTEMROLEPERM_DASHBOARD as SRP on SR.ID = SRP.SYSTEMROLEID
                where 
                    SRP.DASHBOARDCATALOGID = @DASHBOARDCATALOGID
            )