Imo the question needs input data in SQL and the expected output

Or maybe a query

;with test_data as (
    select cast('08/31/2021' as date) as [period date], 
         ...

Maybe try this.  If ISJSON(@j1) equals 1 then it's readable

select oj5.*
from openjson(@j1) oj1
     cross apply openjson(oj1.value) oj2
     cross apply...

Assuming 'Prm' is ordinal maybe something like this

[EDIT] Got rid of comments

;with rn_cte as (
    select *, 
      ...

• This reply was modified 3 years, 11 months ago by Steve Collins.

The word 'key' surrounded by brackets [] is not being displayed.  It's there and I see it when I edit the post.  It's supposed to say "...psuedo-column names 'key' surrounded...

It's tl;dr.  Here's a way to open that piece of JSON tho.  At the end of the day JSON is based on key value pairs.  If you don't provide OPENJSON...

This feels almost like an undocumented "feature" (similar to quirky updates)... I know I would be a bit hesitant in how I used this and would probably continue...

The way I came across this functionality was as a...

You're using C# to do things which could also (better, some might say) be done in SQL Server.  You could use xp_DirTree to read filenames from a folder and use...

There is a MERGE statement which does some data consolidation is being run very 10-15 mins. I dont know why. They are giving weird reasons saying its a business...

Easy. Exactly the rabbit hole we all fall into sometimes.

If life was easy, would any of us have a job? After all, some in politics imply with a couple...

We're trying to identify groupings in events, no?  You've yet to describe or list the exact output you're looking for from the query.  Route 810030 has Grp 10, 16, and...

One way to select intervals where the drop off grouping is hierarchically preferred to the pick up grouping could be to divide the data into two groups: Group1 = BookingID's...

• This reply was modified 4 years ago by Steve Collins.

Old thread on a 7 year delay!  Minor correction to the earlier response tho.  For generic SQL statements the default is OFF, however, for TRIGGERS it's ON.  The documentation only...

Http verb-specific route handlers in .NET 6 filled the last missing piece of the data access puzzle