从Select语句的总和更新值

@dt TVP_API_DELIVERY_ORDER  READONLY    
    UPDATE  Stkm SET
            Stkm.Itm_Qty_OnHand = CASE 
                                    WHEN tvp.Flag='I' THEN (Itm_Qty_OnHand- (SELECT SUM(T1.OrderQty) FROM @dt T1 WHERE T1.ItemCode=tvp.ItemCode)) 
                                    WHEN tvp.Flag='U' THEN ((Itm_Qty_OnHand+(SELECT SUM(T2.Dod_Qty) FROM DoD T2 WHERE T2.Itm_cd=tvp.ItemCode AND T2.Do_No=@OrderNo AND T2.Do_Year=@Year))-(SELECT SUM(T3.OrderQty) FROM @dt T3 WHERE T3.ItemCode=tvp.ItemCode))
                                    WHEN tvp.Flag='D' THEN (Itm_Qty_OnHand + (SELECT SUM(T4.Dod_Qty) FROM DoD T4 WHERE T4.Itm_cd=tvp.ItemCode AND T4.Do_No=@OrderNo AND T4.Do_Year=@Year))                                          
                                    ELSE 0
                                  END       
    FROM     @dt tvp 
    INNER JOIN Stkm ON tvp.ItemCode=Stkm.Itm_Cd
@dt TVP_API_DELIVERY_ORDER  READONLY    
    UP