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 - 16:21:22 CET

This message: [ Message body ]
Next message: Ted Byers: "Re: How can a group by clause be modified so the end weeks of the year won't be split?"
Maybe in reply to: toby: "Re: How can a group by clause be modified so the end weeks of the year won't be split?"
In reply to Bob Badour: "Re: How can a group by clause be modified so the end weeks of the year won't be split?"
Next in thread: Ted Byers: "Re: How can a group by clause be modified so the end weeks of the year won't be split?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message