Just a suggestion to a newbie that took the time to nicely format their question... if you were to post your question with some readily consumable data, you'd already have...

Thanks for the feedback, Dan.

In a less subtle manner than Phil already explained, I'll tell you that it's flat-out not possible to have those values in a single numeric column.  The ONLY way they...

It's free.  Try it.  If it doesn't work out, upgrade to the Standard Edition.

And do heed Steve's warning about not being able to create jobs or schedule them.  As he...

You cannot prove that a date like 2022-05-09 is actually in the YYYY-MM-DD format.  For example, in SQL Server in the English Language, that will be YYYY-MM-DD but, if it...

I guess they don't understand the concept of "DevOps".  😀

Can't you snuggle up to them and tell them, "Yes, you're correct but I really need your help with a tweak...

Thanks Jeff. Appreciate the detailed insights regarding performance implications. The product team has so far not engaged with regards to a design discussion, but trying nonetheless. I agree that...

Not really.... just do a BULK INSERT from the file.  I haven't had the time to post it but you should...

Yes... there is a drawback.  A fair bit of code will actually run slower because there's an extra lay of structure that you have to go through.  Partitioning is NOT...

You're correct... and I wondered where the heck that reply went. 😛

I can't delete the post but I can change it to nothing.  My apologies for the distraction and apologies...

Why not?  We do so for ever programmable object in SQL Server in the flower box.  It...

I agree that Version Control is of the utmost importance.

Disclaimer:  I have troubles even spelling SSRS correctly. 😉

With that, I hit up a search engine and it appears that there's...

I posted to the wrong thread... post removed. Apologies.

IMHO, it seems to me that you're attacking the wrong issue.  Whatever is creating the bad JSON is the real issue that needs to be fixed.

So, the next step is to include only those tags that you want and you listed those at the following post...

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1

We don't actually need to do that step... The original...