Jeff Moden (12/23/2012)

---

What I'm actually trying to get people to realize is that using JUST the time for this type of stuff (EndTime = StartTime + Duration) is the wrong...

I'm pretty sure you cannot. Neither can use use INTERSECT ALL.

INTERSECT...

Lidou123 (12/19/2012)

---

Hi All,

YEAR WEEKS VALUE ...

Jeff Moden (12/22/2012)

---

Yeah, but as old as this post is, I'm not sure that it answers what needs to...

Dennis - Thanks. Actually I have a "paid for" table of airports that I couldn't post for...

Looked like a single quote when I...

Jeff Moden (12/19/2012)

---

I'm getting some conflicting results on the performance testing. A 10 year old single cpu desktop computer and a laptop probably aren't the best places for me...

Wiki seems to support us:

Common Table Expressions

I typically use exactly the same analogies (non-persistent VIEW or derived tables) but unfortunately I can't be helpful and point you to a link that agrees with us. 🙂

However I...

mister.magoo (12/19/2012)

---

And the nice thing is this method works nicely on varchar(MAX)...

I used 2000 rows of 2000 pairs of values to test :

Duration_AvgCpu_AvgReads_AvgWrites_AvgRowCounts_Avg

106994.000000985614196918 ...

You know the really funny thing. I made the discovery of that approach independently...

"Oh, Magoo! You've done it again!"

BTW. Your DDL setup data was pretty good, except that I needed to fix it a little:

jadelola (12/18/2012)

---

CREATE TABLE [dbo].[DataSheet](

[Acc No] [nvarchar](255) NULL,

[nvarchar](255) NULL,

[PayDate] [datetime]...

You can try the query below. If it produces the correct 3 records you need for each row, just add an INSERT before it to put them into the...

SG - Another thought occurred to me on this question.

I would call this just another form of a "data smear" (a term used by Jeff Moden in this link: http://www.sqlservercentral.com/Forums/Topic1393805-392-1.aspx#bm1393812).