On Tue, Mar 17, 2009 at 5:22 PM, Mark Rotteveel <Avalanche1979@...> wrote:

> Harriv wrote:
>> Yes, this gives the data in correct format (which is nice), but still
>> scans thru whole table? Is it possible to avoid that?
>
> If you want the data of the whole table, it will of course scan through
> the whole table, what did you expect?

I don't want to scan 1000's of records for each day :) Normalized
table structure with DateTable and extra DateID field to original
table is way to go?

>
> --
> Mark Rotteveel
>