UFN_KPIINSTANCE_GETKPICATALOGID

Gets the KPI catalog ID for a given KPI instance ID.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@KPIINSTANCEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_KPIINSTANCE_GETKPICATALOGID(@KPIINSTANCEID uniqueidentifier)
            returns uniqueidentifier
            as
            begin

                declare @RETURNVALUE uniqueidentifier;

                select @RETURNVALUE = KPICATALOGID from dbo.KPIINSTANCE where ID = @KPIINSTANCEID;

                return @RETURNVALUE;

            end;