As frederico and Jeff have already explained the numeric value in the table has no display format of its own.  If you're ok with a type conversion (from numeric to...

'sysdate' is an Oracle function?  Idk the syntax doesn't look like SQL Server

A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many people...

Great information from ratback.  I totally agree about staying within the larger segments as being a good strategy.

The chart I always come back to and track is db-engines.com.  It attempts...

Here's a table valued function which takes as input a (2-part named: schema.name) stored procedure (as column type SYSNAME) and which produces a SQL script some of which could be...

Kind of an odd sentence.  RedGate is in the greater Microsoft cosmos as their...

Can't say anything without seeing the code

Checking back in here.  The OP generated the 15 minute data from the recursive CTE and that's all the data they currently have?  As an aside: a recursive CTE is...

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, 7 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...