Just to ask the question, have you checked the datatype for those columns in the base table?

Thank you all for the comments. I know my code still needs some tweaking. This was a learning process for me. I have in the meantime tried to get...

@jeff Moden, I thank you from my heart for your comment. I greatly respect you and have certainly learned a lot from you. There are no backups because these...

I'm curious... why do you think you need any form of looping for this?

SELECT CONCAT('MERGE ',ChannelReadingTableName,' USING ',MainLevelDataTableName)
  FROM #DeviceChannel

And, be aware... I used the table...

If you look at the number of reads, there's over 7 billion logical reads.  That's more than 56 TERAbytes of I/O.

My first suggestion is to stop the query because it's...

For example, an SSRS reports reads from a table the isn't one of the 'core' tables.  So I have to research where it is created, find it is created...

I was just going to write...

Even there, they don't mention that you should do a CHECKPOINT first...

It does now...

Thank you Jeff,

this did the trick.

I cannot understand why in  a table with about 160,000 rows only one value (not field, but value) displayed this issue. It must have...

Getting back to this post, if you know how to think and how to write good T-SQL (accurate, performant, well documented with comments, and well formatted for readability),...

I've just started reading your article, Manie.  I don't believe you'll find many experts that would crucify anyone for using a cursor for process control.  RBAR process of rows?  Yeah,...

When I said "we", I should have said "they".  What you...

Heh... if you want to have some real fun, have someone successfully answer the question...

Heh... wait for it...