USP_KPIDASHBOARDPAGETABKPIINSTNACE_CREATEORUPDATE

Adds a KPI instance to a user's KPI dashboard page tab.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@KPIDASHBOARDPAGETABID	uniqueidentifier	IN
@KPIINSTANCEID	uniqueidentifier	IN
@SEQUENCE	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_KPIDASHBOARDPAGETABKPIINSTNACE_CREATEORUPDATE(@ID uniqueidentifier = null output,
                @KPIDASHBOARDPAGETABID uniqueidentifier,
                @KPIINSTANCEID uniqueidentifier,
                @SEQUENCE int,
                @CHANGEAGENTID uniqueidentifier)
            as
                set nocount on;

                if @ID is null
                    set @ID = newid();

                if exists(select ID from dbo.KPIDASHBOARDPAGETABKPIINSTANCE where ID = @ID)
                begin
                    update dbo.KPIDASHBOARDPAGETABKPIINSTANCE set KPIDASHBOARDPAGETABID = @KPIDASHBOARDPAGETABID,
                        KPIINSTANCEID = @KPIINSTANCEID,
                        SEQUENCE = @SEQUENCE,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = getdate()
                    where ID = @ID;                    
                end
                else
                begin
                    insert into dbo.KPIDASHBOARDPAGETABKPIINSTANCE (ID,
                        KPIDASHBOARDPAGETABID,
                        KPIINSTANCEID,
                        SEQUENCE,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED)
                    values (@ID,
                        @KPIDASHBOARDPAGETABID,
                        @KPIINSTANCEID,
                        @SEQUENCE,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        getdate(),
                        getdate());
                end;