Garraway, Alun
Alun.Garraway at otto.de
Thu Jan 22 05:12:56 CST 2004
hi, I have a tbl that looks like a spreedsheet, the table looks like this: ART_NR W1 W2 W3 W4 .... W30 110 10 8 12 14 258 20 16 22 13 what I want to do is "normalize" the data like this: ART_NR WEEK ORDERS 110 1 10 110 2 8 110 3 12 110 4 14 258 1 20 258 2 16 etc is that possible (with sql), I can't think of anything :-( alun