UFN_REPORTPARAMETER_GETSYSTEMROLEPERMISSIONSLIST

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