Well, what does the chatbox have to say about this one?  It doesn't look too tricky imo

BTW and just to clarify, I'm damned impressed with what they've been able to get ChatGPT to do.  The technology behind all of that is mind boggling .  My...

Presumably there are other employees besides Betty?  If so it would be convenient to start with a table containing (unique) employees and the sample size.  In the case where you're...

The question came up based on this forum post.  Not sure I'd know the answer otherwise

https://www.sqlservercentral.com/forums/topic/nullif-in-ssis#post-4122037

Afaik JSON treats carriage returns as white space.  At the bottom of this page it says:

Whitespace can be inserted between any pair of tokens

Then there's this...

Afaik this matches the output from the existing query.  To add additional columns you could add additional CROSS APPLY operators and then vary the date inequalities in the WHERE clause(s)

It seems tricky to wade in on this because maybe it's ok the way you're doing it.  Or idk maybe more than one thing is amiss.  Why add columns in...

Well the flip side of that question is, if you're passing the information on to a system that wants to read JSON do you store the sqlified data in...

but do you suppose that they'll actually use your good code to "normalize the data" and store that normalized data in a database or store the JSON and parse...

What could you say about the relationship between the cranes and the fixed locations?  The distances being calculated are between the cranes and the fixed locations?  Can cranes switch locations?

Of course, the differentiated database code is custom. ...

And there's nothing wrong with ratbak's approach.  It could be an efficient way.  The downside is having to do double REPLACE of the array brackets

TBH, I have an extreme dislike for all of the solutions on this thread, not because of how they were coded, but because such code was required to begin...

Sorry I haven't gotten back to you but I had a lot of hospital and doctor appointments lately, so much, I haven't even had a chance to place any bets...

It's valid JSON.  You could try either with two OPENJSON's or one OPENJSON and 2 JSON functions

/* two OPENJSON's */
select SerialNumber, ojc.[value] as ChannelID
from openjson(@json) with (SerialNumber...