Are case statements the best or only way to colomize data that is normalized?
EX:
Store___Account___Fee___Amount___Total
6542____3225______3.25__25.15____28.40
6542____3215______3.25__25.15____28.40
6542____3215______3.25__25.15____28.40
6543____3215______3.25__25.15____28.40
6544____3215______3.25__25.15____28.40
6544____3215______3.25__25.15____28.40
6543____3225______3.25__25.15____28.40
6544____3225______3.25__25.15____28.40
6543____3225______3.25__25.15____28.40
6544____3225______3.25__25.15____28.40
and turn it into:
Store__Fee-3215__Amount-3215__Total-3215__Fee-3225__Amount-3225__Total-3225__
6542___6.50______50.30________56.80_______3.25______25.15________28.40_______
6543___3.25______25.15________28.40_______6.50______50.30________56.80_______
6544___6.50______50.30________56.80_______6.50______50.30________56.80_______
Thanx,
Bill Elvin