select * from table pivot( sum([value]) for [ITEM] in ([A_MAX_CURRENTL],[A_MAX_CURRENTU],[A_MOTOR_PI_COUNTL],....))as s
