peter (11/28/2008)

---

Considdering that for me, just writing a post (let alone a focused one) takes a lot of time and then reading all the work you have put into your...

jacRoberts,

I have SET NOCOUNT ON in the test code so I can't do the verification. Pardon me for asking stupid questions, but I have to check... Have you verified...

Joe Celko (11/28/2008)

---

Let me make an appeal to simple logic.

You build a look-up table once (and if you did a proper calendar table, you also benefit from other uses). ...

I'm not sure what's going on... I ran the code you modified and here's what I got...

===== Set based method with Date table =====

SQL Server Execution Times:

CPU...

That's about what I would expect from an almost real set of random numbers.

The problem is that the boogers are risking our money. :crazy:

Chris Morris (11/28/2008)

---

Testing in my reporting...

... and here's some things to watch out for...

[font="Arial Black"]Performance Tuning: Concatenation Functions and Some Tuning Myths[/font][/url]

Heh... looks like homework questions answered without the OP even trying. 😉

Heh... you know I'd show up with the idea that it "can all be done in T-SQL". Now, if we can just get Microsoft to stop deprecating stuff! ...

Now that's an awesome idea! I wonder how many volumes you could pack onto a single sided DVD?

I've never used MDX queries... that's why I pointed out a traditional cross-tab.

Hugo Kornelis (11/27/2008)

---

Jeff Moden (11/27/2008)

---

Hugo Kornelis (11/27/2008)

---

What I was refering too is the lack of ROW_NUMBER() in SQL Server 2000. This means you'll either have to take your chance with...

Hugo is putting out a lot of...

Heh... guilty as charged. The Phat-Phinger-Phairy made...