UFN_SYSTEMROLE_GETKPIINSTANCELIST

CREATE function dbo.UFN_SYSTEMROLE_GETKPIINSTANCELIST
(
    @SYSTEMROLEID uniqueidentifier
)
/*Returns a table of IDs for all of the KPI instances that have been assigned to the given SYSTEMROLEID.*/
returns table
as
return
(
    select
        SYSTEMROLEKPIINSTANCE.ID,
        SYSTEMROLEKPIINSTANCE.KPIINSTANCEID                    
    from dbo.SYSTEMROLEKPIINSTANCE
    where SYSTEMROLEKPIINSTANCE.SYSTEMROLEID = @SYSTEMROLEID
)