Hi all,
Is it possible to write a select statement that can take a quantity and add that many records to the result?
What I am trying to achieve is to start with a file containing:
Qty Desc
3 Hello
2 Goodbye
And get a resulting table of:
Hello
Hello
Hello
Goodbye
Goodbye
is this possible or must I just use the old Scan and Insert method?
Thanks in anticipation.
Caroline
Caroline