Return the same row more than once

• Hernan A C

  Grasshopper

  Points: 23

  More actions

  March 31, 2006 at 4:08 pm

  #96927

  Hi everyone!

  I'm working on an application that prints labels of customers to be used in normal mail envelopes. The user chooses how many labels of customer's data will be printed.

  I'm using a WHILE loop to select the same row the number of times I need it and insert it in a table variable.

  Is there a better way to do this? I think there could be a better way, but don't know it!

  Thanks in advance!

  Hernan

   

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  April 1, 2006 at 5:14 am

  #630272

  Create a table that contains just numbers - 0, 1, 2, 3, ..., 1000 say.

  Then do a CROSS JOIN to this table from your label data source, where newtable.num < number of copies required.

  ---