Posted by Roy Harvey on 07/11/07 15:51

On Tue, 10 Jul 2007 17:20:57 -0400, Roy Harvey <roy_harvey@snet.net>
wrote:

>SELECT Make, Model
> FROM TheTable as A
> JOIN Numbers as B
> ON N.i BETWEEN 1 AND A.QuantityOrdered

That last line should have tested B.i, not N.i. The column i is the
integer number column of the Numbers table.

Roy Harvey
Beacon Falls, CT

• Next in forum: Re: Import/Export wizard DateTime problem
• Prev in forum: Re: Automatically script out a table & indexes - script needed (2005)
• Thread view: Re: insert loop -- I'm missing the obvious

[Reply to this message]