This concatenates (a bunch of guid's and an expiration date) together and encodes to binary base 64 and converts the result to nvarchar.  The encoded token could be used in...

One area where it seems XML is required is for the conversion/encoding of strings to varbinary base 64.  Altho if there's newer way I'd be interested to hear about it

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 4 years, 1 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...