select statement query

[jonathen]

I have a table with records in that one of the columns (called "entries") has an integer. What I want to do is select all records from the table, but if a row has (for example) 37 as the value for "entries", then that row is selected 37 times.

So for example:

select name,entries from mytable

this returns:

John Smith,37

I'd like to instead return:

John Smith
John Smith
John Smith

...and so on 37 times, or however many times matches the value of the "entries" integer.

Any ideas?

Thanks,

Jon

 

[kulrom]

ok first fetch the entries and pass it to new declared variable i.e. Dim myEntries as integer

Then use a loop
For i as integer = 0 to myEntries
'reader object
Next

At least i would make it like that

HTH
Regards