Please help me with that SQL script, I'm hopeless :( I have a "product" table which has: product_cat (identity, int, i.e=4) and product_list (which is a "$$" delimited list of products, i.e - mouse_wheel$$screen$$keyboard) - don't ask... about 400,000 rows.
I have a "info" table that looks like this: product_item (mouse_wheel, for example) and product_description (text explanation about mouse_wheel) about 2,000,000 rows (!) I want to combine the two tables, in a long process. What I need is that for every row on the PRODUCT table, SQL would delimit each item from product_list and update its INFO table occurence with the appropriate product_cat. come to think of it, I can simulatinsoluy update severl products with the same product_cat (because I have a list of different products, delimited). Further more, I need a unique identifier for each row (i.e - on every item, to add an increment identity integer, never mind the order). so in the end I will have an organized row that will include all information for SINGLE product. can anyone help me with that? Michael. ICQ: 3056792 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
