更新SQL Server中的Select Case语句：
更新SQL Server中的Select Case语句：
提问于 2012-05-10 11:47:12
我编写了下面的update语句来更新PLN_DU_Vendor表的StatusID。
UPDATE
PLN_DU_Vendor
SET
PLN_DU_Vendor.StatusID = 2
FROM
PLN_DU_Vendor
INNER JOIN PMT_RFDDetail D ON PLN_DU_Vendor.DUID = D.DUID
INNER JOIN PMT_RFDHeader H ON H.RFDID = D.RFDID AND PLN_DU_Vendor.VendorID = H.VendorID
INNER JOIN PLN_LASCO_Header LH ON LH.LASCOID = H.LASCOID AND LH.ReleaseID = PLN_DU_Vendor.ReleaseID
AND PLN_DU_Vendor.VendorDUQuantity = (D.DespatchQuantity + ISNULL(PLN_DU_Vendor.RFDQuantity, 0))
WHERE
H.RFDID = 10如果条件
PLN_DU_Vendor.VendorDUQuantity = (D.DespatchQuantity + ISNULL(PLN_DU_Vendor.RFDQuantity, 0))失败，我需要将StatusID更新为1。如何在相同的update select语句中执行此操作。
回答 2
Stack Overflow用户
回答已采纳
发布于 2012-05-10 11:58:11
看起来您需要将条件作为CASE语句从JOIN移动到赋值：
UPDATE
PLN_DU_Vendor
SET
PLN_DU_Vendor.StatusID = CASE
WHEN PLN_DU_Vendor.VendorDUQuantity = (D.DespatchQuantity + ISNULL(PLN_DU_Vendor.RFDQuantity, 0))
THEN 2
ELSE 1
END
FROM
PLN_DU_Vendor
INNER JOIN PMT_RFDDetail D ON PLN_DU_Vendor.DUID = D.DUID
INNER JOIN PMT_RFDHeader H ON H.RFDID = D.RFDID AND PLN_DU_Vendor.VendorID = H.VendorID
INNER JOIN PLN_LASCO_Header LH ON LH.LASCOID = H.LASCOID AND LH.ReleaseID = PLN_DU_Vendor.ReleaseID
WHERE
H.RFDID = 10Stack Overflow用户
发布于 2012-05-10 12:00:35
不能将任何浮点数与运算符=进行比较
PLN_DU_Vendor.VendorDUQuantity = (D.DespatchQuantity + ISNULL(PLN_DU_Vendor.RFDQuantity, 0))所以，最好是
PLN_DU_Vendor.VendorDUQuantity - (D.DespatchQuantity + ISNULL(PLN_DU_Vendor.RFDQuantity, 0)) < ERROR页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/10527248
复制相关文章
相似问题
腾讯云开发者
