请教这个是哪里格式不对
日期：2014-05-17 浏览次数：20561 次
请问这个是哪里格式不对？
select ISNULL(totaltime.totaltime,0)/ISNULL(totalcount.totalcount,1)
from
(select SUM(DATEDIFF(HOUR,receivedate + ' ' + receivetime,case isnull(operatedate,'') when '' then '2012-10-30 23:59:59' else operatedate + ' ' + operatetime end)) as totaltime
from View_Workflow_ActOperator as a inner join HrmResource as b on a.userid = b.id inner join workflow_nodebase as c on a.nodeid = c.id where c.isstart = 0 and c.isend = 0 and b.subcompanyid1 = 7
)as totaltime
left join
(select count(1) as totalcount
from View_Workflow_ActOperator as a inner join HrmResource as b on a.userid = b.id inner join workflow_nodebase as c on a.nodeid = c.id where c.isstart = 0 and c.isend = 0 and b.subcompanyid1 = 7
) as totalcount
总是在最后一个totalcount后面显示红色波浪线
------解决方案--------------------
把left join改成逗号
------解决方案--------------------
select ISNULL(totaltime.totaltime,0)/ISNULL(totalcount.totalcount,1)
from
(select SUM(DATEDIFF(HOUR,receivedate + ' ' + receivetime,case isnull(operatedate,'') when '' then '2012-10-30 23:59:59' else operatedate + ' ' + operatetime end)) as totaltime
from View_Workflow_ActOperator as a inner join HrmResource as b on a.userid = b.id inner join workflow_nodebase as c on a.nodeid = c.id where c.isstart = 0 and c.isend = 0 and b.subcompanyid1 = 7
)as totaltime
left join
(select count(1) as totalcount
from View_Workflow_ActOperator as a inner join HrmResource as b on a.userid = b.id inner join workflow_nodebase as c on a.nodeid = c.id where c.isstart = 0 and c.isend = 0 and b.subcompanyid1 = 7
) as totalcount
总是在最后一个totalcount后面显示红色波浪线
------解决方案--------------------
把left join改成逗号
------解决方案--------------------
SELECT ISNULL(( SELECT SUM(DATEDIFF(HOUR, receivedate + ' ' + receivetime,
CASE ISNULL(operatedate, '')
WHEN '' THEN '2012-10-30 23:59:59'
ELSE operatedate + ' ' + operatetime
END)) AS totaltime
FROM View_Workflow_ActOperator AS a
INNER JOIN HrmResource AS b ON a.userid = b.id
INNER JOIN workflow_nodebase AS c ON a.nodeid = c.id
WHERE c.isstart = 0
AND c.isend = 0
&n
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
