Just remember that you'll end up with a rather huge transaction log file on Step 3 and it will take 2-3 times longer if you don't achieve "Minimal Logging".

That's a rather huge TempDB considering the relatively small size...

Thanks Jeff for those pointers. I am basically checking for an extended event trace definition file to track these numbers.

I never used sp_blitz and not sure how it will...

Yes it's just an encoding.  How could one perform such an encoding without XML?  That's the hijacked topic 🙂  As an aside: I associated the encoding with a conversion...

Thank you Jeff, for your follow-up!

The entire table might exist or not. The reason for that—versions of the particular app, so the query must be just one but run...

Sounds like your transaction log being full is putting a stop to replication. There is no need to "shrink" the log file if it is just going to grow...

Until we know for sure that the left side is absolutely guaranteed to be 4 digits with no leading zeros and the same with the right side with no leading...

Apologies for the numerous posts.  I just find problems like this to be interesting.

I was using literal integers instead of variables before.  In previous versions of SQL Server, that used...

If there's a guaranteed 4 significant digits to the left and no more than 7 digits to the right, this will also work.  It still has the issue of being...

Well blow me down.  I took my other post I had here down.  The string method Jonathan posted beats even the pure integer math in this case.

Here's the test table...

Have you actually had to do such a thing where you work?

Does the table actually exist and you're just checking to see if the column exists or will the table actually be missing?

In either case, I'm pretty sure that you're going...

Here's the code to get the two values as separate integers.  I've also included code to concatenate them as a string.  I still don't believe that joining them together is...

I take it that the zero's between the two obvious parts could be consumed by an increasing value of the right part or will it ALWAYS be 7 digits (no...

One area where it seems XML is required is for the conversion/encoding of strings to varbinary base 64.  Altho if there's newer way I'd be interested to hear about...