Posted by brymcguire on 05/11/07 07:57

On 10 May, 23:22, --CELKO-- <jcelko...@earthlink.net> wrote:
> >> I know how to establish the last day of the previous month part, I'm just not sure of how best to design the remainder of the query. <<
>
> Instead of using procedural coding, why not use a table of the
> reporting periods for a decade or two? A simple BETWEEN predicate
> will classify each sale quickly and give you extra control over non-
> operating days, etc.

Hi Joe,

Thanks for the feedback. Your solution of "using a table of reporting
periods" was one of a number that I did think about at the time.
However, as I have learned over the years when it comes to using SQL,
there is , as we somtimes say here in the UK, "more than one way to
skin a cat..."

Now I'm not saying that I won't adopt your solution, just that its
good for me to have a number of "options" up my sleeve.

By the way I have read and own a number of your books. They have been
a big help :)

Thanks

Bryan

• Next in forum: Re: How does UPDATE statement work?
• Prev in forum: How does UPDATE statement work?
• Thread view: Re: Last Day Of Previous Month...with a twist

[Reply to this message]