Ian Gibson (8/19/2008)

---

That's interesting. I had my doubts as to how useful pivot might be. It's good to see it backed up by examples and statistics.

I'm looking forward to what...

Peter Smith (8/19/2008)

---

What a performance! Access SQL had the Pivot command from 1992, it's taken 13 years for...

Phil Factor (8/19/2008)

---

[p]I hope I'm not mentioning anything that you are covering in subsequent articles, but when you need row and column totals, averages, or other aggregations, then suddenly the...

DB_Andrew (8/18/2008)

---

There are times when you don't always have the time to come up with the proper set based solution. Now I'm not saying you should take the quick...

Actually, I've gotta be up in 5 hours... I'll finish this tomorrow evening. Heh... don't change that channel! 😛

Heh... but since he challenged my method, I get the...

Here's some "simpler" code for the "single run" test... the cteTally split blows the SELECT/UNION ALL method away by 51.7 times on my box. I didn't put it in...

Trevor,

This thread kinda got hijacked... are you all set?

Sorry Marcello... a bit of ignorance on my part showing... didn't realize you were doing it in MDX and I know just about nothing about MDX. My appologies.

bodhilove (8/18/2008)

---

Hope you don't find my explanation too dry...

I am transfering a 2000 db to 2005. I haven't been given a test environment to work with. I am migrating by...

Dave (8/18/2008)

---

I was wondering when you'd show up to ask me that, Jeff 🙂

I have a stored procedure that creates files that are emailed as attachments by sp_send_dbmail. ...

bluepaperbag (8/18/2008)

---

Mr. Jeff,

Yes, the 40 tables have different columns but they all have the same createdate and changedate columns which helps for the incremental extract.

The format has to be pipe...

If there's that big a price difference, I'm thinking that the OEM version may be the Standard Edition...

You bet... thank you for the feedback.../ 🙂

Did you try the function I gave you?