Re: Help with sql-query

hehe caused a bit of a stir here , didn't mean to it was just a throw away comment.

The post was meant to be a seed, not a fully fledged solution, hence absence of indexes etc... unfortunately there aren't enough hours in the day for me to post justification (ala Kimballs excellent DW book). In fact I have found that its not just DW's, and reporting that benefit from Calendar_Dates I have used it in many complex manufacturing processes and its proved to be invaluable. Not clutter, not a kludge a core table (which when maintained properly) becomes invaluable to the function of the business.

"Let's assume that a developer determines that using inline views is not elegant or well designed, simply because the concept is foreign, "

I love inline views - but would rather join to a table ;-)

Apologies for upsetting you Charles, don't take it personally! Received on Mon Jun 25 2007 - 04:48:06 CDT