Heh... OK. If you're going to throw a conversation on the floor with stuff like that, I guess this conversation is over.

You bet. Thanks for the feedback, Alex. 🙂

David.Poole (10/5/2008)

---

Does it work? Yes

Should it be used? Not if you want a robust scaleable solution.

In the environment where I work we had to buy and install a...

I never said I would. 😉

Heh... what a teaser you are. You just know that I'm going to challenge Phil's findings, don't ya? 🙂

...AND, if you really want to pivot the data as you say (I still think it's a mistake), take a look at the following article. If you use a...

You might also want to describe the analysis you intend to do. I see where you say what you think you need to do to the data, but you...

Heh... yeah, for you, maybe. If you want my help, please post it in the readily consumable form along with a table creation statement like I asked for in...

Don't get me wrong... I'm not bad mouthing your code or your article... I actually gave it a good mark. 😀

There's only one item on a list of benefits that...

You'll actually be increasing the level of complexity to do the analysis if the analysis will be done by computer and not a human.

Post some data according to the specs...

No problem... it's easy either way... just needed to know which way. 🙂

See if this doesn't fit the bill... It does require a Tally table which you can get at...

So? It's a great tool and it's a hell of a lot better than redistributing code everytime you need to make a change. Teach the users how to...

vidhyasudha (10/5/2008)

---

HI Jeff,

Temp table will be the structure I mentioned. Two base tables doesn't share any relation. This is due to the fact that database is migrated to sql 2005...

Do the Google search I spoke of... that will be one of the things that show up.

Heh. Thanks, Dugi... I appreciate the feedback. 🙂