非常奇怪的问题,莫名其妙报错:
消息 8169,级别 16,状态 2,第 1 行
将字符串转换为 uniqueidentifier 时失败。
如下注释部分代码后,就能正常查询出结果
SELECT DISTINCT ZB.*
-- ,(case Item_LWBH
-- WHEN '无' THEN
-- ''
-- ELSE Item_LWBH end) AS Item_LWBH,(case Item_JJCD
-- WHEN '特急公文' THEN
-- Item_LWBH
-- ELSE '' end) AS Item_JJCD
from
(SELECT *
FROM WorkFlowTask a
WHERE a.ID IN
(SELECT TOP 1 ID
FROM WorkFlowTask
WHERE FlowID=a.FlowID
AND a.ReceiveID='120e5db8-8479-4d6d-ab47-92a1557ea878'
AND GroupID=a.GroupID
ORDER BY charindex('120e5db8-8479-4d6d-ab47-92a1557ea878',ReceiveID) desc,Sort DESC)
AND a.Status IN(0,1,5)
AND a.FlowID IN('98a586d0-e287-49cd-a811-cabe1f4d203c')) ZB left join
(SELECT DISTINCT ReceiveID AS UserId,
InstanceID
FROM [RoadFlowWebForm].[dbo].[WorkFlowTask]) CB
ON ZB.InstanceID=CB.InstanceID
LEFT JOIN [dbo].[LDocument_Management]
ON [LDocument_Management].Item_Id=ZB.InstanceID