Posted by --CELKO-- on 05/10/07 22:22

>> 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.

• Next in forum: Re: How Import XML file in a table with trigger.
• Prev in forum: Re: DBCC INPUTBUFFER results into table
• Thread view: Re: Last Day Of Previous Month...with a twist

[Reply to this message]