SQL合并语句

我正在尝试使用 SQL Server 2008 中新的“MERGE”语句。该语句将从临时表中获取记录，并在其他表中更新相同的记录。该语句如下：

create table #TempTable(ProcPOAmdDel_ProcessAmendmentId bigint,ProcPOAmdDel_SemiFinProdId bigint,ProcPOAmdDel_ChallanQty int)

MERGE PurProcessPOAmendmentDelivery AS pod
USING (SELECT ProcPOAmdDel_ProcessAmendmentId,
       ProcPOAmdDel_SemiFinProdId FROM #TempTable ) AS temp
ON pod.ProcPOAmdDel_ProcessAmendmentId = temp.ProcPOAmdDel_ProcessAmendmentId AND 
   pod.ProcPOAmdDel_SemiFinProdId=temp.ProcPOAmdDel_SemiFinProdId 
WHEN MATCHED THEN UPDATE 
  SET pod.ProcPOAmdDel_ChallanQty = temp.ProcPOAmdDel_ChallanQty;

运行状态时我遇到错误 Invalid columns name'ProcPOAmdDel_ChallanQty'。

有人可以帮我解决这个问题吗？

在源表（即临时表）中包含列 ProcPOAmdDel_ChallanQty

MERGE PurProcessPOAmendmentDelivery AS pod
USING (SELECT ProcPOAmdDel_ProcessAmendmentId,
              rocPOAmdDel_SemiFinProdId,
              ProcPOAmdDel_ChallanQty
       FROM #TempTable ) AS temp
ON pod.ProcPOAmdDel_ProcessAmendmentId = temp.ProcPOAmdDel_ProcessAmendmentId AND 
pod.ProcPOAmdDel_SemiFinProdId=temp.ProcPOAmdDel_SemiFinProdId 
WHEN MATCHED THEN 
UPDATE SET pod.ProcPOAmdDel_ChallanQty = temp.ProcPOAmdDel_ChallanQty;