Posted by Ed Murphy on 11/23/06 09:22

Roy Harvey wrote:

> AND B.WeekID BETWEEN A.WeekID - 4 and B.WeekID

Did you mean A.WeekID there at the end?

• Next in forum: Re: appending two datetimes which were converted from strings
• Prev in forum: Re: Help with FOR XML - How do I return the results like this?
• Thread view: Re: Count Query Question

[Reply to this message]