The key here is to realize the misnomer.  What you find in SSMS is NOT a full version of RegEx.  I'm not sure it even qualifies as a valid...

The problem here is that the regex search and replace for SSMS was changed to use Visual Studio regex search and replace https://docs.microsoft.com/en-us/visualstudio/ide/using-regular-expressions-in-visual-studio?view=vs-2022 but the documentation was never updated...

You're not checking to see whether the bank name has already been updated, so you keep updating the same 4999 records repeatedly.  Add something to the WHERE clause to check...

SELECT 'class1' AS [@ClassName]
    , 'String' AS [ExternalId/@TYPE]
    , a.AccountNumber AS ExternalId
FROM #Account AS a
FOR XML PATH('Element')

Drew

To put it another way, you have to first update the existing table to replace all NULL values in that column with non-NULL values before you can alter the table...

It's not clear what you mean by "complete attr3".  I've tried several possibilities and none of them work for all records.  This is the closest that I got.  It uses...

So the wrong solution to the wrong problem,  What you actually need is a table (or tables) that ulimately hold the commission allocation details: SalesMan, Customer, Start, End  and...

I believe that this does close to what you are looking for.  It can probably be massaged to do exactly what you want.  The big problem is that the trailing...

Ive been writing t-SQL code for 25 years and NEVER come across FIRST_VALUE, LAST_VALUE.  I have always written a RANK() OVER() or a MIN() OVER() in a CTE and...

This is a personal preference, but I find your case structure difficult to parse and comprehend.

Instead of your

where finvdate < Case when Month(current_timestamp) = 1 then
Dateadd(year,...

First, whenever you use date/time intervals, you should always use half-closed intervals (one side includes '=' and the other does not).  This is required for DATE data, but it's good...

We're not mind readers.  You got an error message, but failed to mention that in your original post.  How are...

The best way to answer questions like this is to try it.  If it works, great! If it doesn't work, then you can post here to figure out why it...

Also, don't cross post.  You now have four separate threads with the same question.

My best guess is that you are using the wrong partition.  Without data is hard to determine what the correct partition is, but I would hazard that you should be...