Eric M Russell (8/13/2015)

---

Luis Cazares (8/13/2015)

---

Eric M Russell (8/13/2015)

---

Luis Cazares (8/13/2015)

---

Ed Wagner (8/13/2015)

---

Eric M Russell (8/13/2015)

---

But where do you get your tally? There are examples out there; Jeff's is popular....

Eric M Russell (8/13/2015)

---

Luis Cazares (8/13/2015)

---

Ed Wagner (8/13/2015)

---

Eric M Russell (8/13/2015)

---

But where do you get your tally? There are examples out there; Jeff's is popular. However, it would be nice...

You have a circular reference and duplicate rows in your sample data. Is that correct?

Ed Wagner (8/13/2015)

---

Eric M Russell (8/13/2015)

---

But where do you get your tally? There are examples out there; Jeff's is popular. However, it would be nice if SQL Server would provide...

Dwain's article is a great resource. Hopefully, it will help the OP.

Could you explain why do you say that the median is wrong? It's the average of the 2 middle...

Brandie Tarvin (8/13/2015)

---

Luis Cazares (8/12/2015)

---

jasona.work (8/12/2015)

---

So, my laptop offered me the Win10 upgrade. I figured I'd sign up for it (laptop was recently reloaded to Win7 Pro) and worst...

Wait

Do you need help to make the query work on 2008? Or are you fine now? Did you understand the solution?

That discussion should be interesting. However, there's no hurry on creating it. Leave it for a better moment.

My condolences go out to you and your family. I hope that you...

Koen Verbeeck (8/13/2015)

---

OK, I didn't select the option with the in-memory table, because the sentence ends with only.

This made me believe the answer suggested that you could only create columnstore...

jasona.work (8/12/2015)

---

So, my laptop offered me the Win10 upgrade. I figured I'd sign up for it (laptop was recently reloaded to Win7 Pro) and worst case I can dump...

Deja Vu

Lynn Pettis (8/12/2015)

---

Probably, but so was his WTF in his OP and then the bashing because we didn't give him the...

Does the assignment need to be balanced?

An idea:

SELECT DATEDIFF(second,Information.[Start Time],Information.[End Time]) / 60.00 / 60.00,

CEILING( DATEDIFF(second,Information.[Start Time],Information.[End Time])*4 / 60.00 / 60.00) / 4 AS Rounded_Hours,

ROUND( DATEDIFF(second,Information.[Start Time],Information.[End...