+1.

select id,1*part1 from #cars where part1 > 0

union

select id,2*part2 from #cars where part2 > 0

union

select id,3*part3 from #cars where part3 > 0