Posted by Roy Harvey on 07/10/07 21:20

You need a Numbers table with the integers 1 through at least the
maximum number from the QuantityOrdered column. Then you can simply:

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

Roy Harvey
Beacon Falls, CT

On Tue, 10 Jul 2007 14:01:54 -0700, eighthman11 <rdshultz@nooter.com>
wrote:

>I have a table on sql server. It has three columns (1-Make) (2-Model)
>(3-Quantity Ordered). I'm simplifying this a bit.
>
>Sample data:
>
>Ford Mustang 3
>Chevy Camaro 2
>
>I just need a stored procedure that I can run that will insert those
>records into a workfile based on the Quantity ordered, so if you have
>3 ordered in the first table like above it will insert the columns
>Ford and Mustang into the workfile 3 times (3 records) and likewise
>the Chevy record Twice for (2 records)
>
>Example results of workfile:
>
>Ford Mustang
>Ford Mustang
>Ford Mustang
>Chevy Camaro
>Chevy Camaro
>
>This can't be that difficult but I am not a sql programmer. Any help
>would be appreciated.

• Next in forum: Re: ISQL is truncating contents of text field sent to text file.
• Prev in forum: insert loop -- I'm missing the obvious
• Thread view: Re: insert loop -- I'm missing the obvious

[Reply to this message]