[1nf] Forum Topics

I have data in which column 'C' have cells which contain multiple values separated by (,).Now I want to get atomic values in all cells of column 'C'. i.e. that for a cell when there is more than one value; separated by (,) it should be copied in the next …

Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2006 15-Jan-2006 15-Jan-2006 15-Jan-2006 16-Jan-2006 PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, …

Hello all hope this section isn't abandoned, anyway any help is really appreciated. Heres my problem: So I'm designing this database to hold orders, a customer places an order, which can have up to four accessories, at first I designed this table: [LIST] [*]idOrder[*]Acc1[*]acc2[*]acc3[*]acc4 [/LIST] but then I realized that …