Duplicate Order Details and Increment 1

[sathandle]

I have an order fulfillment application that is trying to generate multiple copies of the same order so the order document can be placed on each individual box.

How can I create a data source that duplicates all of the orders a given number of times. Therefore, if I need 7 copies of Order #1001, it prints 1001-1; 1001-2; 1001-3; etc. X varies by the order, but is calculatable. Is it possible to do this without the use of a temporary table?

I have posted a similar question on the Reporting Services forum.

Thoughts? Ideas for implementation?

SATHandle


Don't beat your head against the wall unless you know how to plaster.

 

[r937]

see thread-553683

r937.com | rudy.ca

 

[sathandle]

THANK YOU!!!

It worked like a charm!!! To add to the efficiency of the creation of the integers table:

DECLARE @Value int
SET @Value = 1

create table tblIntegers (i integer)
WHILE @Value<=100
BEGIN
PRINT @Value
insert into tblIntegers (i) values (@Value)
SET @Value = @Value + 1
END


Don't beat your head against the wall unless you know how to plaster.