USP_KPIINSTANCEMILESTONE_GETLIST

Gets a list of milestones for a given KPI instance.

Parameters

Parameter	Parameter Type	Mode	Description
@KPIINSTANCEID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_KPIINSTANCEMILESTONE_GETLIST(@KPIINSTANCEID uniqueidentifier)
            as
                set nocount on;

                select VALUE,
                    ASOFDATE,
                    UPWARDLOWVALUE,
                    UPWARDMIDVALUE,
                    DOWNWARDMIDVALUE,
                    DOWNWARDHIGHVALUE
                from dbo.KPIINSTANCEMILESTONE
                where KPIINSTANCEID = @KPIINSTANCEID
                order by ASOFDATE;