Thank you, problem is fixed!

As per your recommendations, I modified my stored proc., so it is now looks like this:

ALTER PROCEDURE [dbo].[pOgGetActivityReqInfo1]

AS

--create temp table to preserve result set...

I have the same filling about "Update" statement - this is a source of a problem.

RunID is "Identity":

CREATE TABLE [dbo].[ActivityRunArchive](

[MessageID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[RunID] [int] IDENTITY(1,1) NOT NULL,

[ActivityID] [int] NOT...