USP_KPIDASHBOARDPAGE_DELETEBYAPPUSERID

            create procedure dbo.USP_KPIDASHBOARDPAGE_DELETEBYAPPUSERID(@APPUSERID uniqueidentifier, @CHANGEAGENTID uniqueidentifier)
            as
                set nocount on;

                declare @e int;
                declare @contextCache varbinary(128);

                /* cache current context information */
                set @contextCache = CONTEXT_INFO();

                /* set CONTEXT_INFO to @CHANGEAGENTID */
                if not @CHANGEAGENTID is null
                    set CONTEXT_INFO @CHANGEAGENTID

                delete from dbo.KPIDASHBOARDPAGE where APPUSERID = @APPUSERID;

                /* reset CONTEXT_INFO to previous value */
                if not @contextCache is null
                    set CONTEXT_INFO @contextCache

                select @e=@@error;

                if @e<>0 return -456; --always return non-zero sp result if an error occurs


                return 0;