... Check out Lynn's date/time conversions blog post. The link is in my signature block below.

Gotta love it when my messed up solution (unused cte) actually worked and solved it.

... Actually, I just plain forgot to remove it. I think they call that A-G-E???

This seems like it works:

WITH SAMPLE (REFERENCE_ID,TECH_MODE_ID,BEGIN_TIME,END_TIME) AS

(

SELECT 1, 6, CONVERT(DATETIME,'2012-05-03 20:29:22'),CONVERT(DATETIME,'2012-05-03 20:29:52') UNION ALL

SELECT 1, 5, '2012-05-03 20:29:53','2012-05-03 20:29:55' UNION ALL

SELECT 1, 5, '2012-05-03 20:29:56','2012-05-03 20:30:03' UNION ALL

SELECT 1,...

I'm assuming that your table has columns like:

cs1_start, cs1_end, cs2_start, cs2_end, etc.

Is there any particular reason that you didn't create a properly normalized, separate table for this data?

userId

courseId

start

end

(FK link back...

Okay, so I've been pretty busy lately. And I just got back from going on the "SQL Cruise". Friday I was up to Philly for SQL Sat. And I get...

I want to thank Lawrence, Andrew, opc, Skamath, Haining, Alex, Jeff and Sean for all the kind and positive words for me. Thanks a bunch for the feedback.

Andrew Diniz (6/8/2012)

---

Thanks to Wayne for an awesome article! And thanks others for great discussion.

There's one point that no one picked up that I find inaccurate:

Note that the estimated execution...

sparky-407434 (6/8/2012)

---

I had been using temp tables in a large import process and made the change to table variables and saw a big improvement in performance. However, the server was...

opc.three (6/8/2012)

---

Very well done. I especially like the comparison table you produced. I have plans to refer some developers to read this article as the misuse of Table Variables is...

KeePass[/url] works great for me.

SQL Kiwi (5/22/2012)

---

His...

Has anyone heard from Gianluca since the earthquake in northern Italy? I think he's up in that area, and just want to make sure that he's okay.

Stefan Krzywicki (5/21/2012)

---

WayneS (5/21/2012)

---

SQLRNNR (5/21/2012)

---

On the flip side, I think I will attend the Rhode Island SQL Saturday. That means I will miss the NH SQLSat (sorry Jack) and...

SQLRNNR (5/21/2012)

---

On the flip side, I think I will attend the Rhode Island SQL Saturday. That means I will miss the NH SQLSat (sorry Jack) and attend the Salt...

Steve Jones - SSC Editor (5/21/2012)

---

SQLRNNR (5/21/2012)

---

The pizza was not so good - but hey.

I had too much info to cover in 1hr15. I will be trimming it back...