大家帮助,很急.........谢谢..在线等待

Question

上面的where sendno='519' 是不要.写错了

Answer 1

select DrAdvice,AllTotal,id,DrAdviceID
from
(select DrAdvice,AllTotal,id,DrAdviceID,FeetypeName from VIEWCheck 
union
select FeetypeName as  DrAdvice,sum(AllTotal) as AllTotal,null,null,FeetypeName as  FeetypeName from VIEWCheck group by FeetypeName
)t
order by FeetypeName,id

Answer 2

SELECT dbo.VIEWSendAdvice.DrAdvice, dbo.AccountVIEW.AllTotal, 
      dbo.VIEWSendAdvice.State, dbo.VIEWSendAdvice.Sendno, 
      dbo.VIEWSendAdvice.SendDept, dbo.VIEWSendAdvice.id, 
      dbo.VIEWSendAdvice.EntryTime, dbo.VIEWSendAdvice.SendDeptName, 
      dbo.VIEWSendAdvice.FeetypeName, dbo.VIEWSendAdvice.DrAdviceID, 
      dbo.VIEWSendAdvice.SendNurse, dbo.VIEWSendAdvice.disposeTime, 
      dbo.VIEWSendAdvice.ReceiveNurse, dbo.InpatientRegister.InpatientCode, 
      dbo.InpatientRegister.InvalidName, dbo.InpatientRegister.BeginDate, 
      dbo.DeptCode.name_Dept, dbo.InpatientRegister.OnceItem, 
      dbo.InpatientRegister.Sex, dbo.InpatientRegister.Age, dbo.InpatientRegister.BedNo, 
      dbo.VIEWSendAdvice.ReceiveTime, dbo.VIEWSendAdvice.disposeTime AS Expr1, 
      dbo.InpatientRegister.DeptNo, dbo.InpatientRegister.DelFlag
FROM dbo.AccountVIEW INNER JOIN
      dbo.VIEWSendAdvice ON 
      dbo.AccountVIEW.InHospID = dbo.VIEWSendAdvice.InHospID AND 
      dbo.AccountVIEW.DrAdviceID = dbo.VIEWSendAdvice.DrAdviceID INNER JOIN
      dbo.DeptCode INNER JOIN
      dbo.InpatientRegister ON dbo.DeptCode.Id_Dept = dbo.InpatientRegister.DeptNo ON 
      dbo.VIEWSendAdvice.InHospID = dbo.InpatientRegister.InpatientCode AND 
      dbo.VIEWSendAdvice.SendDept = dbo.InpatientRegister.DeptNo

Answer 3

wangdehao(找找找) ( ) >:你的结果是一样的
运行提示:
服务器: 消息 8618，级别 16，状态 2，行 1
警告: 查询处理器未能用优化程序生成查询计划，因为 GROUP BY 或 ORDER BY 子句中所有列的总长度超过了 8000 字节。
请大家帮帮我

Answer 4

AccountVIEW这个应该也是一个视图吧？

Answer 5

FeetypeName是char(50)
AccountVIEW也是视图
请问能用别的方法吗,

Answer 6

select FeetypeName as  DrAdvice,sum(AllTotal) as AllTotal,null,null,FeetypeName as  FeetypeName from VIEWCheck group by FeetypeName
--单独执行下面语句会报错吗？

Answer 7

wgsasd311(自强不息):单独执行不错

Answer 8

wgsasd311(自强不息):你有什么好办法吗,请帮助我

Answer 9

我试了一下 你的 where sendno='519' 去掉就好了