SELECT dbo.nb_JiaBanLog.FormNumber, dbo.nb_JiaBanLog.WorkId, dbo.nb_EMPLOYEE.EMPLOYEENAME,
dbo.DEPT.DEPTNAME, dbo.nb_EMPLOYEE.DEPTID, CONVERT(varchar(100),dbo.nb_JiaBanLog.PlanStartTime,120)
as PlanStartTime, CONVERT(varchar(100),dbo.nb_JiaBanLog.PlanEndTime, 120) as
PlanEndTime, dbo.nb_JiaBanLog.PlanTotal, dbo.nb_JiaBanLog.Checked FROM
dbo.nb_JiaBanLog INNER JOIN dbo.nb_EMPLOYEE ON dbo.nb_JiaBanLog.WorkId = dbo.nb_EMPLOYEE.EMPLOYEEID
INNER JOIN dbo.DEPT ON dbo.nb_EMPLOYEE.DEPTID = dbo.DEPT.DEPTNO INNER JOIN
dbo.nb_jiaBan ON nb_jiaBan.jb_FormNumber=nb_JiaBanLog.FormNumber where
dbo.nb_JiaBanLog.WorkId='042215' and dbo.nb_JiaBan.CASEID NOT IN
(SELECT CASEID FROM dbo.TASK WHERE (PLANSN = '37') AND (BEHAVIOR = '7') OR (PLANSN = '37') AND (DEL = 'Y'))and 查询前一天的资料
后面的怎样写还是用getdate()-1 吗?
dbo.DEPT.DEPTNAME, dbo.nb_EMPLOYEE.DEPTID, CONVERT(varchar(100),dbo.nb_JiaBanLog.PlanStartTime,120)
as PlanStartTime, CONVERT(varchar(100),dbo.nb_JiaBanLog.PlanEndTime, 120) as
PlanEndTime, dbo.nb_JiaBanLog.PlanTotal, dbo.nb_JiaBanLog.Checked FROM
dbo.nb_JiaBanLog INNER JOIN dbo.nb_EMPLOYEE ON dbo.nb_JiaBanLog.WorkId = dbo.nb_EMPLOYEE.EMPLOYEEID
INNER JOIN dbo.DEPT ON dbo.nb_EMPLOYEE.DEPTID = dbo.DEPT.DEPTNO INNER JOIN
dbo.nb_jiaBan ON nb_jiaBan.jb_FormNumber=nb_JiaBanLog.FormNumber where
dbo.nb_JiaBanLog.WorkId='042215' and dbo.nb_JiaBan.CASEID NOT IN
(SELECT CASEID FROM dbo.TASK WHERE (PLANSN = '37') AND (BEHAVIOR = '7') OR (PLANSN = '37') AND (DEL = 'Y'))and 查询前一天的资料
后面的怎样写还是用getdate()-1 吗?
解决方案 »
- 百分求助!c# 使用webbrowser控件问题,自动登录页面后,点新页面自动返回初始登录系统
- 模版(母板)怎么使用
- 画线慢的问题,折磨我两个星期了!!!!
- 征求例子一个.(初学)
- 想问一下,datagrid每一行都会随着鼠标的动作改变颜色
- 有关实现outlook重复约会功能的实现(没有太多思路)
- .net的 linkbutton在有的浏览器不能正常使用
- 小政哥:javascript脚本执行了没有结果的奇怪问题?
- XML 这东西真混蛋。
- asp.net mvc datagrid 数据批量插入数据库
- 紧急求救!在线等,一有答案就结贴,顶者有分
- gridview中的dropdownlist显示问题
And DateDiff( 'dd ',getdate(),datecolum) = 1
提示:
訊息 1023,層級 15,狀態 1,行 10
指定給 datediff 的參數 1 無效。
And DateDiff(dd,getdate(),datecolum) = -1
datediff的首参数不是字符串.
And DateDiff( 'dd ',getdate(),datecolum) = 1
前一天。这里写反了And DateDiff( 'dd ',datecolum,getdate()) = 1