Now where is that crystal ball again?

😎

Here is a quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATA_1818603') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA_1818603;

create table dbo.TBL_SAMPLE_DATA_1818603

(

dates datetime

,customer int

,ind_1 smallint

,ind_2 smallint

,ind_3 smallint

,ind_4 smallint

)

insert into dbo.TBL_SAMPLE_DATA_1818603

...

Quick question, why is the latest date in the sample set 2015-03-01? This means that the data is all excluded by the requirements.

😎

This weekend is the Open House weekend in London, just wondering if SSC is participating in something similar like Open Spam:pinch:

😎

sqlfriends (9/16/2016)

---

I have a developer wrote code using a lot of CTEs in a stored procedure.

Basically, one CTE call another CTE call another CTE.

CTE is sometimes easy to understand, but...

TomThomson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight loss? What? Eat...

Good job and thanks for...

Phil Parkin (9/16/2016)

---

Jacob Wilkins (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid...

Jacob Wilkins (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight...

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight loss? What? Eat more...

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more...

tripleAxe (9/15/2016)

---

Here is the UNION ALL query using a temp table so that we can have one pass at the input table as suggested by The Dixie Flatline in an...

There is another way of getting a single scan plan and that is to use an inline tally table, here are two harnesses, 5 and 50 columns respectfully.

😎

5 column harness

USE...

Here is a 50 column test harness and the results on my old laptop (2nd Gen i5)

😎

USE TEEST;

GO

SET NOCOUNT ON;

--http://www.sqlservercentral.com/Forums/FindPost1817858.aspx

-- TEST HARNESS

DECLARE @timer TABLE (

T_TXT...

Thank you Tomaž for this nice write-up, very good indeed!

😎