27,580
社区成员
发帖
与我相关
我的任务
分享
SELECT '配方' AS ExitStatus, COUNT(DISTINCT Charge.ID) AS Pages, COUNT(DISTINCT List.ID) AS Num,
SendUser.user_name AS UserID, Charge.sDeptCode + '-' + MedType.Name AS MedTypeName
FROM In_wsz_ChargeSum Charge
INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
INNER JOIN In_wsz_MedType MedType ON Charge.MedType = MedType.MedType
WHERE (Charge.SendStatus = 1) AND (Charge.MedType = 11 OR Charge.MedType = 12
OR Charge.MedType = 13 OR Charge.MedType = 14) AND (Charge.SendTime > '2018-05-16 00:00:00')
AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name, MedType.Name, Charge.sDeptCode
UNION ALL
SELECT '电子处方' AS MedTypeName, '配方' AS ExitStatus, COUNT(DISTINCT Charge.ID) AS Pages,
COUNT(DISTINCT List.ID) AS Num, SendUser.user_name AS UserID FROM In_wsz_ChargeSum Charge
INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
INNER JOIN In_wsz_MedType MedType ON Charge.MedType = MedType.MedType
WHERE (Charge.SendStatus = 1) AND (Charge.MedType <> 24 AND Charge.MedType <> 34
AND Charge.MedType <> 11 AND Charge.MedType <> 12 AND Charge.MedType <> 13 AND Charge.MedType <> 14
AND Charge.MedType<>82) AND (Charge.SendTime > '2018-05-16 00:00:00')
AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name
UNION ALL
SELECT '配方' AS ExitStatus, COUNT(DISTINCT Charge.ID) AS Pages, COUNT(DISTINCT List.ID) AS Num,
SendUser.user_name AS UserID, Charge.sDeptCode + '-' + MedType.Name AS MedTypeName
FROM In_wsz_ChargeSum Charge INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
INNER JOIN In_wsz_MedType MedType ON Charge.MedType = MedType.MedType
WHERE (Charge.SendStatus = 1) AND (Charge.MedType = 24 OR Charge.MedType = 34)
AND (Charge.SendTime > '2018-05-16 00:00:00') AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name, MedType.Name, Charge.sDeptCode
UNION ALL
SELECT '退方' AS MedTypeName,COUNT(DISTINCT Charge.ID) AS Pages, COUNT(DISTINCT List.ID) AS Num,
'退方' AS ExitStatus, SendUser.user_name AS UserID FROM In_wsz_ChargeSum Charge
INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
WHERE (Charge.MedType =82) AND (Charge.SendStatus = 1)
AND (Charge.SendTime > '2018-05-16 00:00:00') AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name
SELECT COUNT(DISTINCT Charge.ID) AS Pages, COUNT(DISTINCT List.ID) AS Num,
SendUser.user_name AS UserID, Charge.sDeptCode + '-' + MedType.Name AS MedTypeName, '配方' AS ExitStatus
FROM In_wsz_ChargeSum Charge
INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
INNER JOIN In_wsz_MedType MedType ON Charge.MedType = MedType.MedType
WHERE (Charge.SendStatus = 1) AND (Charge.MedType = 11 OR Charge.MedType = 12
OR Charge.MedType = 13 OR Charge.MedType = 14) AND (Charge.SendTime > '2018-05-16 00:00:00')
AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name, MedType.Name, Charge.sDeptCode
UNION ALL
SELECT COUNT(DISTINCT Charge.ID) AS Pages, COUNT(DISTINCT List.ID) AS Num,
SendUser.user_name AS UserID ,'电子处方' AS MedTypeName,'配方' AS ExitStatus
FROM In_wsz_ChargeSum Charge
INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
INNER JOIN In_wsz_MedType MedType ON Charge.MedType = MedType.MedType
WHERE (Charge.SendStatus = 1) AND (Charge.MedType <> 24 AND Charge.MedType <> 34
AND Charge.MedType <> 11 AND Charge.MedType <> 12 AND Charge.MedType <> 13 AND Charge.MedType <> 14
AND Charge.MedType<>82) AND (Charge.SendTime > '2018-05-16 00:00:00')
AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name
UNION ALL
SELECT COUNT(DISTINCT Charge.ID) AS Pages, COUNT(DISTINCT List.ID) AS Num,
SendUser.user_name AS UserID, Charge.sDeptCode + '-' + MedType.Name AS MedTypeName,'配方' AS ExitStatus
FROM In_wsz_ChargeSum Charge INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
INNER JOIN In_wsz_MedType MedType ON Charge.MedType = MedType.MedType
WHERE (Charge.SendStatus = 1) AND (Charge.MedType = 24 OR Charge.MedType = 34)
AND (Charge.SendTime > '2018-05-16 00:00:00') AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name, MedType.Name, Charge.sDeptCode
UNION ALL
SELECT COUNT(DISTINCT Charge.ID) AS Pages, COUNT(DISTINCT List.ID) AS Num,SendUser.user_name AS UserID,
'退方' AS MedTypeName,'' AS ExitStatus FROM In_wsz_ChargeSum Charge
INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
WHERE (Charge.MedType =82) AND (Charge.SendStatus = 1)
AND (Charge.SendTime > '2018-05-16 00:00:00') AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name
好吧,好像不是,我不知道为啥,我整理了顺序,然后 出现在将 varchar 值 '电子处方' 转换成数据类型 int 时失败。为什么啊?SELECT '电子处方' AS MedTypeName, '.' AS ExitStatus, COUNT(DISTINCT Charge.ID) AS Pages,
COUNT(DISTINCT List.ID) AS Num, SendUser.user_name AS UserID FROM In_wsz_ChargeSum Charge
INNER JOIN In_wsz_ChargeMedList List ON Charge.ID = List.SumChargeID
INNER JOIN public_user_list SendUser ON Charge.SendUserID = SendUser.user_name
INNER JOIN In_wsz_MedType MedType ON Charge.MedType = MedType.MedType
WHERE (Charge.SendStatus = 1) AND (Charge.MedType <> 24 AND Charge.MedType <> 34
AND Charge.MedType <> 11 AND Charge.MedType <> 12 AND Charge.MedType <> 13 AND Charge.MedType <> 14
AND Charge.MedType<>82) AND (Charge.SendTime > '2018-05-16 00:00:00')
AND (Charge.SendTime < '2018-05-16 23:59:59')
GROUP BY Charge.SendUserID, SendUser.user_name
我找到在第二段出现错误,为什么出错啊?找不到原因