I too am curious how the project is going or went. I definitely wasn't trying to say "don't do it", I was just trying to say to be careful...

Ha, a haunting could be a good thing 🙂

This sounds like an interesting project and I'm wondering how it turned out.  Mr. Brian Gale made good points but there are workable solutions around.  Some backend developers are web...

That makes sense.  I was going to ask if maybe another script runs at the same time.  Afaik processing-wise, the IF condition and the ALTER TABLE statement are 2 separate...

Regarding the use of...

How to calculate the product of all of the denominators for each group?  Why doesn't...

The larger query I have has many fields with converts etc. so I am trying not to add the CustomerId to the nested query to get the sum somehow...

Assuming the parts to be split are: 1) the sentence on the left, and 2) the single string on the right.  It appears after the initial 50 character split of...

In Visual Studio working with git (and GitHub, Gitlab, etc.) seems more streamlined and user friendly.  SSMS clunky.  For almost everything SQL Server related I use VS but still have...

Maybe you could try OFFSET and FETCH NEXT on the righthand side of OUTER APPLY

declare
  @nth_from_top       int=2,
  @nth_from_bot ...

The problem in Steve's solution is that is doesn't account for possible CR/LF data in the last field.  In your data - there is a CR\LF after the comma...

Bump for visibility

Here's the code I'm running and the results I'm seeing.  The @string value was copy/pasted.  Thanks btw to Jeff for the splitter code.

drop FUNCTION if exists [dbo].[DelimitedSplitN4K];
go
CREATE...

I did originally post this question under my personal account and this is from my work account.

I did think about using a second replace statement but could not devise...

One way could be to use the same replacement technique as with the line breaks.  Replace the "," and ", and ," with |.  Then replace any remaining double quotes...