UFN_KPIINSTANCEHISTORY_GETVALUE

Gets the value of a KPI instance as of a given date.

Return

Return Type
decimal(19, 5)

Parameters

Parameter	Parameter Type	Mode	Description
@KPIINSTANCEID	uniqueidentifier	IN
@ASOFDATE	datetime	IN

Definition

Copy



            create function dbo.UFN_KPIINSTANCEHISTORY_GETVALUE(@KPIINSTANCEID uniqueidentifier,
                @ASOFDATE datetime)
            returns decimal(19, 5)
            as
            begin

                declare @RETURNVALUE decimal(19, 5);

                select top(1)  @RETURNVALUE = VALUE 
                    from KPIINSTANCEHISTORY 
                    where KPIINSTANCEHISTORY.KPIINSTANCEID = @KPIINSTANCEID
                        and KPIINSTANCEHISTORY.ASOFDATE <= dbo.UFN_DATE_GETLATESTTIME(@ASOFDATE) 
                    order by KPIINSTANCEHISTORY.ASOFDATE desc

                return @RETURNVALUE;

            end;