标题:[求助]sql代码那里错了
只看楼主
xinyu13520
Rank: 1
等 级:新手上路
帖 子:37
专家分:0
注 册:2006-12-12
 问题点数:0 回复次数:1 
[求助]sql代码那里错了
SELECT N'' AS SelCol, isotype, ID, bRdFlag, cVouchType, cVouchName, dmadedate,
cBusType, cBusCode, cbarcode, cassunit, innum, inquantity, cSource, cWhCode,
cWhName, dDate, cCode, cRdCode, cRdName, cDepCode, cDepName, cPersonCode,
cPersonName, cSTCode, cSTName, cCusCode, cCusAbbName, cOrderCode,
cBillCode, cDLCode, cMaker, cHandler, cAccounter, cMemo, cbvencode, cvenname,
cItemCode, cName, cItem_class, id_1, cItemCName, cInvCode, cInvAddCode,
cInvName, cInvStd, cBatch, iNum, iInvExchRate, cInvM_Unit, iQuantity, iUnitCost,
iPrice, iPUnitCost, iPPrice, dVDate, cPosition, cReplaceItem, AutoID, cVouchCode,
ipurorderid, ipurarriveid, iproorderid, iarriveid, dVeriDate, isalebillid,
(CASE WHEN bpufirst = 1 THEN N'是' ELSE N'否' END) AS bpufirst, iMPoIds,
iCheckIds, imassdate, cmassunit, cInVouchCode, iId, iSoutQuantity, iSoutNum, VT_ID,
(CASE WHEN bIsSTQc = 1 THEN N'是' ELSE N'否' END) AS bIsSTQc, cChkCode,
dChkDate, cChkPerson, dARVDate, bGsp, cGspState, iDLsID, iSBsID, iEnsID,
iSendNum, iSendQuantity, gspcheck, cposname, cDefine1, cDefine2, cDefine3,
cDefine4, cDefine5, cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, cDefine11,
cDefine12, cDefine13, cDefine14, cDefine15, cDefine16, cdefine22, cdefine23,
cdefine24, cdefine25, cdefine26, cdefine27, cDefine28, cDefine29, cDefine30,
cDefine31, cDefine32, cDefine33, cDefine34, cDefine35, cDefine36, cDefine37,
cInvDefine1, cInvDefine2, cInvDefine3, cInvDefine4, cInvDefine5, cInvDefine6,
cInvDefine7, cInvDefine8, cInvDefine9, cInvDefine10, cInvDefine11, cInvDefine12,
cInvDefine13, cInvDefine14, cInvDefine15, cInvDefine16, cFree1, cFree2, cFree3,
cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, ufts, ccusinvcode,
ccusinvname, cshipaddress, strcontractid, strcode, isoseq, csocode, igrossweight,
inetweight
FROM KCSaleOutList
WHERE dDate >= N'2007-01-01' AND ((1 > 0) AND (1 > 0)) AND (AutoId IN
(SELECT id
FROM tempdb..tmp12123177tmp)) AND cVouchType = N'32' AND isnull(bIsSTQc, 0)
<> 1 AND ISNULL(bPuFirst, 0) <> 1 AND ISNULL(bIAFirst, 0) <> 1
ORDER BY cdefine23 DESC
搜索更多相关主题的帖子: sql 代码 
2007-07-04 17:25
jn55589156
Rank: 1
等 级:新手上路
帖 子:5
专家分:0
注 册:2007-4-28
得分:0 
写整齐点看起来比较好找
2007-07-08 06:33



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-152725-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.149128 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved