SQL query to duplicate records X times

[Timalaugh]

Hi all...
I have an odd one.
I need to be able to duplicate a record thisMany times where ThisMany is a field in the record. The table I start with only has one record. The problem is I need to do it in one select statement. Any one know how to do this.

thanks very much

Tim

 

[PWise]

Create A numbers table

One field digitid type int

insert values from 1 till XXXX
insert into yourtabel (fields)
Select fields,....
From yourTable
inner join numberstable
on Digitid<=fieldinyourtable

 

[Timalaugh]

excellent...
got it
thanks