| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 525 人关注过本帖
标题:[求助]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
快速回复:[求助]sql代码那里错了
数据加载中...
 
   



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

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