Style-wise, the joins are specified in "more specific to less specific" order which imo is not the standard way and it's less read-able.  Without knowing anything about the underlying data...

• This reply was modified 4 years, 10 months ago by Steve Collins.
• This reply was modified 4 years, 10 months ago by Steve Collins.

The query references "a couple of joined tables" but the code listed only has 1 table 't' in the FROM clause.  The error message "multi-part identifer ..." happens when the...

The nested subqueries seem not to be necessary imo.  What is the point of selecting the top 15 rows only to select the top 1 from that subset using the...

It appears the OP is referencing Excel functions and column arrays.  In this query the calculated NewColumn equals the DesiredColumn.

drop table if exists #tTable;
go
create table #tTable(
 ...

Yes, the other 13 start with 0, meaning 'dbo.fnTally(0,...

I use 2 monster .sql scripts to answer SSC/SO questions.  One currently has 13,787 lines and contains 32 occurrences of 'fnTally' of which 24 specify the sequence begin with 1. ...

Those are my two choices so...

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