Update Multiple Columns In One Sql Statements

I am almost sure I can update variables columns in one select/case type


statement, but having problems working out the syntax.





I have a table with transactions - with tran types as the key.





in this example, types = A,B,C ,D.





in this first example I am updating the sum of QTY to value t_A based on


tran types =A.





can I perform sub query/case to update with the same where clause


but for types B,C and D?? I also have to insert for specific lot numbers each sum values.











Create table #t_reconcile(


t_lot_number int not null,


t_A float,


t_B float,


t_C float,


t_D float)








insert #t_reconcile





select t.lot_number, sum(t.qty)


from i , t


where i._id = t.event_id


i.transaction_type = 'A'


group by t.lot_number


order by t.lot_number