Nice piece as always Gail, made me giggle a little as when I read it, I had just finished a very similar exercise which brought the execution time of a...

Quick question, can you share some more details?

😎

Edit: typo

sgmunson (6/9/2015)

---

You may want to look at performance. With small amounts of data,...

Steve Jones - SSC Editor (6/9/2015)

---

Nothing is ever simple, and the queries that do this potentially slow way down with...

ChrisM@Work (6/9/2015)

---

Steve Jones - SSC Editor (6/9/2015)

---

Nothing is ever simple, and the queries that do this potentially slow way down...

mpdillon (6/9/2015)

---

Thanks for your replies. I should have thought about the UNION. I will try that now.

I do not understand how to create a CTE from a CTE. Could you...

Quick suggestion, add another CTC and filter the output from there.

😎

GilaMonster (6/8/2015)

---

Well here's a new slant on the 'partitioning for performance'...

Switch the partitions that are needed out to a staging table, do processing on the staging table then switch...

Specialization

Same as pietlinden's, adjusted to the required output

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#Temp') IS NOT NULL DROP TABLE #Temp;

CREATE TABLE #Temp(

[ROWNUMBER] [float] NULL,

[Component] [float] NULL,

[M/O No] [float] NULL,

[Opening Balance] [float]...

Quick solution, works with the sample data

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SampleData (REQCODE, PERSON, STARTDATE, ENDDATE, STARTTIME, ENDTIME, ...

Monarchy

Donor

Alvin Ramard (6/4/2015)

---

Eirikur Eiriksson (6/4/2015)

---

Jeff Moden (6/4/2015)

---

Shifting gears a bit...

Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think...

Jeff Moden (6/4/2015)

---

Shifting gears a bit...

Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a thing would...