Probably not. The STRING_SPLIT function is relatively crippled for those that...

drop table if exists #Stats2;
go
CREATE TABLE [dbo].#Stats2
       ([StatsDate] [datetime] PRIMARY KEY,
       [TypeA_Calls] [int] NULL,
 ...

• This reply was modified 5 years, 2 months ago by Steve Collins.

What if there is more than one 'Period Key' for a (Support_Start_Date, Support_End_Date) pair?

Maybe you're looking for something like this?  It returns multiple rows if the (Support_Start_Date, Support_End_Date) pair spans...

declare 
  @sql_prefix   nvarchar(max)=N'select id.PartIdC, id.PartIdX,',
  @sql_suffix   nvarchar(max)=
  N'from #InputData id
     left join #partsdata p1 on...

I am currently trying to backfill data from an S3 bucket, to SQL server using Alteryx. Unfortunately, there is a lot of data and running a month at...

Please post the CREATE TABLE Data Definition Language (DDL) of both of your tables.  Without knowing how the keys (PK_POSTE , FK_POSTE) and constraints are defined we don't have enough...

Using conditional aggregation

select NAME_POSTE, 
       max(iif(NAME_PARAM='NamePrinter', VALUE_PARAM, null)) NamePrinter,
       max(iif(NAME_PARAM='PathPrinter', VALUE_PARAM, null)) PathPrinter
from #P p
...

Here's a non-dynamic query to produce the output.  If there's a variable number of features then it would need to be dynamic.

select id.PartIdC, id.PartIdX,
   ...

One way or another I would like to come up with a way to deal with JSON schemas.  If I observe how my time is spent and do the...

with zpl_cte(Zplid) as (
    select Zplid
    from #gen
    group by Zplid
    having count(*)=3
  ...

Yep... and I didn't...

Don't re-use @I.  Come up with a new variable to store the counter for the inner...

To fix the first issue you could add 'order_num' to the GROUP BY clause.

Not sure why 'Dry Feed' doesn't show.  It's using an equivalent of the 'Dry Feed' WHERE clause...

Why is this necessary?  Here's a solution using (two of) the fnTally function to generate the rows instead of WHILE loops.  Re-using declared variables is generally not a good...

Sorry it's been a busy day!  Please give this a try

declare
  @start      datetime='2020-11-29 00:00:00.000',
  @end     ...

• This reply was modified 5 years, 2 months ago by Steve Collins.