ramadesai108 (12/26/2008)

---

Hi David,

I previsouly added the case statement in the group by, but forgot to add it in the order by and that's where the problem...

Yep... we all agree on that. I believe the main complaint is... the documentation doesn't say anything about the default size.

Interesting concept... but it doesn't work correctly. I ran the code and the test code, as is... the results are not exactly a cross tab... look at the scores...

Perry Whittle (12/25/2008)

---

Lynn Pettis (12/17/2008)

---

since it needs to create the table on the fly it doesn't know how big the column needs to be so it so it makes it...

Heh... only 365 brain cell shopping days left...

Man, I sure hope they survive... I don't believe folks understand what an impact they've had on the United States and North America in general in the last 100 years....

Oh yeah... almost forgot... you need a Tally table for that code to work... please see the following...

[font="Arial Black"]

The "Numbers" or "Tally" Table: What it is...

Kit Brandner (12/22/2008)

---

Try a 23-character long alphanumeric PIN code with certain characters excluded for legibility that can't be repeated in the database. So Jeff's solution wouldn't work. I suppose I...

Heh... there's an Auto Industry in Michigan??? 😉

I find both those things to be true with a lot of authors.

You're supposed to ask for them BEFORE Christmas! 😛

For what it's worth, I agree... if you compare the way the very...

RBarryYoung (12/24/2008)

---

You know I am really not crazy about...

Merry Christmas and Happy New Year to you, too, Sandy... and to everyone else, as well.

BWAAA-HAAA! Sounds like a heck of a tagline for a new company, Barry 😛