SELECT ITEMNO,CODE,DN,CBDESC,(SELECT TOP (1) QTY FROM JOBT WHERE JOBNO =V_PRQT.WO)BQTY,QTY,
(CASE WHEN SH ='0.74' THEN SH = '1' else SH END)SH,(QTY*(ISNULL(SH,0)))SHS,UNIT,(QTY)DDQS,(QTY)WLXQ,
DDATE,VEN,WO FROM V_PRQT WHERE PRQNO='HCPRQ1111183' Order by WO
'=' 附近有语法错误。
(CASE WHEN SH ='0.74' THEN SH = '1' else SH END)SH,(QTY*(ISNULL(SH,0)))SHS,UNIT,(QTY)DDQS,(QTY)WLXQ,
DDATE,VEN,WO FROM V_PRQT WHERE PRQNO='HCPRQ1111183' Order by WO
'=' 附近有语法错误。
我说的布详细
后面then是不需要的那个sh=的
(SELECT TOP (1) QTY FROM JOBT WHERE JOBNO =V_PRQT.WO)BQTY,QTY,
(CASE WHEN SH ='0.74' THEN '1' else SH END)SH,
(QTY*(ISNULL(SH,0)))SHS,UNIT,
(QTY)DDQS,(QTY)WLXQ, DDATE,VEN,WO
FROM V_PRQT
WHERE PRQNO='HCPRQ1111183' Order by WO
(CASE WHEN SH ='0.74' THEN '1' else SH END)SH,(QTY*(ISNULL(SH,0)))SHS,UNIT,(QTY)DDQS,(QTY)WLXQ,
DDATE,VEN,WO FROM V_PRQT WHERE PRQNO='HCPRQ1111183' Order by WO
(CASE SH WHEN 0.74' THEN '1' else SH END)SH,(QTY*(ISNULL(SH,0)))SHS,UNIT,(QTY)DDQS,(QTY)WLXQ,
DDATE,VEN,WO FROM V_PRQT WHERE PRQNO='HCPRQ1111183' Order by WO
(CASE SH WHEN '0.74' THEN '1' else SH END)SH,(QTY*(ISNULL(SH,0)))SHS,UNIT,(QTY)DDQS,(QTY)WLXQ,
DDATE,VEN,WO FROM V_PRQT WHERE PRQNO='HCPRQ1111183' Order by WO
SELECT ITEMNO,CODE,DN,CBDESC,(SELECT TOP (1) QTY FROM JOBT WHERE JOBNO =V_PRQT.WO)BQTY,QTY,
(CASE WHEN SH ='0.74' THEN '1' else SH END)SH,(QTY*(ISNULL(SH,0)))SHS,UNIT,(QTY)DDQS,(QTY)WLXQ,
DDATE,VEN,WO FROM V_PRQT WHERE PRQNO='HCPRQ1111183' Order by WO
/*
(CASE WHEN SH ='0.74' THEN '1' else SH END) 这样写
CASE WHEN SH ='0.74' THEN SH = '1' else SH END 错误的
*/