USP_KPIINSTANCEMILESTONE_ADD

Adds a milestone value to a KPI instance.

Parameters

Parameter	Parameter Type	Mode
@KPIINSTANCEID	uniqueidentifier	IN
@VALUE	decimal(19, 5)	IN
@ASOFDATE	datetime	IN
@UPWARDLOWVALUE	decimal(19, 5)	IN
@UPWARDMIDVALUE	decimal(19, 5)	IN
@DOWNWARDMIDVALUE	decimal(19, 5)	IN
@DOWNWARDHIGHVALUE	decimal(19, 5)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_KPIINSTANCEMILESTONE_ADD(@KPIINSTANCEID uniqueidentifier, 
                @VALUE decimal(19, 5),
                @ASOFDATE datetime,
                @UPWARDLOWVALUE decimal(19, 5),
                @UPWARDMIDVALUE decimal(19, 5),
                @DOWNWARDMIDVALUE decimal(19, 5),
                @DOWNWARDHIGHVALUE decimal(19, 5),
                @CHANGEAGENTID uniqueidentifier)
            as
                set nocount on;

                insert into dbo.KPIINSTANCEMILESTONE (KPIINSTANCEID,
                    ASOFDATE,
                    VALUE,
                    UPWARDLOWVALUE,
                    UPWARDMIDVALUE,
                    DOWNWARDMIDVALUE,
                    DOWNWARDHIGHVALUE,
                    DATEADDED,
                    DATECHANGED,
                    ADDEDBYID,
                    CHANGEDBYID)
                values (@KPIINSTANCEID,
                    @ASOFDATE,
                    @VALUE,
                    @UPWARDLOWVALUE,
                    @UPWARDMIDVALUE,
                    @DOWNWARDMIDVALUE,
                    @DOWNWARDHIGHVALUE,
                    getdate(),
                    getdate(),
                    @CHANGEAGENTID,
                    @CHANGEAGENTID);