one post is enough thanks...

there's no problem splitting dates with triggers if you want to.
I use group by on non-split dates and do not experience any performance
issues. So I'm not sure what your issues here are.
Alan

Thanks Alan.
And how do you do to group by by the month in the date? Or by the day in
the date?



________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________