Generate repeated values in target table
Posted: Wed Jun 21, 2006 1:48 am
I have a scenario wherein I have some 2000 records in target table. There is one source table in which only one field is there (say 10 random values). There is no joiing condiiton between these tables. I have to poplulate one of my taget columns with this source field and have to run the job as many values are there in source. In the end I should have 2000*10 records in my target table. 2000 records will repeat for each value of the source field. and that value I have to populate in one of my target columns.
How can I do this?
How can I do this?