Getting back to Itzik's challenge, I had a question form in my mind.  As a pre-amble to the question, I've found that I use "1" as a starting number...

I think maybe it should be 'where c.id=o.cust_id'  🙂

The table #tmpTabl specifies the column 'id' twice.  Presumably the second 'id' is the unique identifier of the 'orders' table so here it's renamed as 'o_id'.

drop table...

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

By "work" if you mean "give the right answer" then no.  It doesn't return any error though.  But...

Yes the logic is broke.  I agree with all of Alan's comments.  It seems possible to take corrective steps using cte(s) and additional windowing functions where the cardinality of the...

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