Hello.. Can someone help me out with this....
I have a table of over a million records, and getting much larger, one of the fields in the table contains product names, with a space separating each product. Now I need to export the data in this field into a new table, but rather than insert the data in the product fields as one record, if there exist 3 products in that field, then I want three records in the new table, one for each product. Example.. Table 1 The product field has something like that - date,product1 product2 product3,... When I Export it to table 2 I would like something like this Date, product 1 Date, product 2 Date, product 3 And there is no telling the number of products in each field, some might have one, some more. This must be done as an SQL process, could be a very easy thing for some, but I never did anything like this is SQL, some help would be appreciated. ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
