Basically, what it boils down to is that SQL Server does not hold on to "old" data unless you explicitly do something to keep track of it, such as create...

Here's the detail on using the function Grant refers to:CREATE TABLE #Participants (
    Participant varchar(100) NOT NULL PRIMARY KEY CLUSTERED,
    ParticipantID int IDENTITY(1,1) NOT NULL
);
INSERT INTO #Participants (Participant)

Without a much more detailed understanding of your tables, their structure, and what a record in each of the tables is intended to represent, this is largely impractical for someone...

So.... what are you planning to do with the February inserts after inserting the January data?   You may well end up with a LOT more rows than you need.   That...

You can use PIVOT, but it will force you to either hard code it each run, or have to use dynamic SQL.   If you take out the PIVOT and use...

My first guess would have been that the user that you specify for Server B does not have UPDATE rights on Server B for the table on Server B, but...

I agree with the idea that the existence of the "Low" range and it having a numeric value associated with it has "difficulties" where meaning is concerned.  The question is,...

Well, it doesn't appear that you have the connection pooling enabled, but I'd go through the actual connection configuration and see if there's any settings in there that could cause...