USP_KPIINSTANCE_GETLISTBYKPICATALOGID

Returns a list of KPI instances for a given KPI catalog item.

Parameters

Parameter	Parameter Type	Mode	Description
@KPICATALOGID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_KPIINSTANCE_GETLISTBYKPICATALOGID(@KPICATALOGID uniqueidentifier)
            as
                set nocount on;

                select KPIINSTANCE.ID,
                    KPIINSTANCE.NAME,
                    KPIINSTANCE.DESCRIPTION
                from dbo.KPIINSTANCE
                where KPIINSTANCE.KPICATALOGID = @KPICATALOGID
                order by KPIINSTANCE.NAME;