It would be interesting to see...

I assume SQL 2019 for David, but I do think it's hard to regression test. I don't know how many of us have a decent set of things to...

Maybe split twice using an ordinal string splitter.  If there's more than 1 (www.domin.org)'s this would split them all.  Splitter is available at this link

DROP TABLE...

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