Re: How can a group by clause be modified so the end weeks of the year won't be split?

From: -CELKO- <jcelko212_at_earthlink.net>
Date: Thu, 29 Jan 2009 07:21:22 -0800 (PST)
Message-ID: <6992ba37-62bf-4915-a09f-733774c4965b_at_z27g2000prd.googlegroups.com>



>> Since a function is just a relation with particular qualities, what is the theoretical difference between joining to a table to get the WEEK and calling a WEEK function? <<

The theoretical answer is that one defines the set by intention and the other extension.

The practical answer is that a look-up table is adjustable for holidays and irregular reporting periods. And there is a very good chance it will run faster because of simple indexing and in parallel because the table can be hashed over several processors. Received on Thu Jan 29 2009 - 09:21:22 CST

Original text of this message