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

• This reply was modified 5 years, 1 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, 1 months ago by Steve Collins.

The second post makes the first one clearer.  In the first post the 2nd query in the statement containing UNION ALL is the only place where 'Dry Feed' is defined...