No apologies needed Jeff. I just know I have to edit your code before I run it. Happens all the time with code from OP's as well.

Jeff Moden (1/28/2009)

---

Michael Valentine Jones (1/28/2009)

---

Matt Miller (1/28/2009)

---

Michael Valentine Jones (1/27/2009)

---

Going by 120 yards by 50 yards for an American football field (100 yards goal-to-goal plus 2x10 yard end zones...

Jeff Moden (1/28/2009)

---

Lynn Pettis (1/28/2009)

---

smunson (1/28/2009)

---

Jeff,

I have a relatively fresh installation of SQL 2005 Developer Edition, but your object in the following:

.

.

.

FROM Master.dbo.SysColumns t1 CROSS JOIN Master.dbo.SysColumns t2

.

.

.

doesn't exist on...

David Reed (1/28/2009)

---

The way that publik skrewel (in the US anyway) teaches "suppository writing" leads many, many people astray. Proper paraphrasing, citation and fair use are NOT taught these days....

Thank you. :blush:

Carla Wilson (1/28/2009)

---

Lynn Pettis (1/28/2009)

---

68% of both boys and girls surveyed admitted to cheating on tests in school.

56% of the boys and 45% of the girls felt that cheating is...

Thank you. (Still, that would have been a good gift to someone on SSC, even if it wasn't me.)

smunson (1/28/2009)

---

Jeff,

I have a relatively fresh installation of SQL 2005 Developer Edition, but your object in the following:

.

.

.

FROM Master.dbo.SysColumns t1 CROSS JOIN Master.dbo.SysColumns t2

.

.

.

doesn't exist on my server. ...

People are trying to help you, unfortunately you don't seem to help them. You have been asked questions, and given some suggestions, yet I have yet to see any...

You beat me to it. I guess he thought if he started a new thread he'd get a different answer.

I didn't test Jeff's code against just one partition, but from what I saw of the data when run against the whole table, I'd have to say that in that...

John Dempsey (1/28/2009)

---

I...

Can we actually purchase SQL Server 2008 Developer Edition yet. Last time I looked it still wasn't on the Microsoft website, just SQL Server 2005 Developer Edition. (Too...

My concern is actually data growth. The database may only be 2GB today, next year it could be 4GB. Seems like you end up constantly adding more hardware...

YeshuaAgapao (1/28/2009)

---

Makes sense now. I would still suggest that if the running totals requirement was the dominant form of querying on the table, I would rather just un-partition the...