sqlserver字符转换错误

SELECT B01_JB01_R.B00 AS DMCOD ,
        ISNULL(DMPARENTCOD, '00000000-0000-0000-0000-000000000000') AS DMPARENTCOD ,
        '1' AS DMPARENTLEV ,
        JB04_hiber.nodeid AS NODEID ,
        '1' AS ISB01 ,
        RIGHT('00000' + CAST(JB04.InpFrq AS NVARCHAR(50)), 5) AS INPFRQ
FROM    B01_JB01_R
        INNER JOIN JB04_hiber ON B01_JB01_R.Nodeid = JB04_hiber.nodeid
        INNER JOIN JB04 ON JB04.Dmcod = JB04_hiber.dmcod
UNION
SELECT  ZB02_Hiber.DmCod ,
        (CASE WHEN DmParentCod = '00000000-0000-0000-0000-000000000000' AND B01_JB01_R.B00 IS NOT NULL THEN B01_JB01_R.B00 ELSE DmParentCod END) AS DmParentCod,
        1 AS DmParentLev,
        CASE B01_JB04_R.NodeID WHEN '0A6BDA5C-8305-4F5C-B41C-CB0B7157EF84' THEN 'B8652ADC-E096-47E1-88FE-D14DBF7B3F9E' ELSE B01_JB04_R.NodeID END AS NODEID ,
        '1' AS ISB01 ,
        b02.BJXB0123 AS INPFRQ
FROM    dbo.ZB02_Hiber
        INNER JOIN dbo.ZB02 ON ZB02.DmCod = ZB02_Hiber.DmCod
        INNER JOIN dbo.B01_JB04_R ON B01_JB04_R.B00 = ZB02_Hiber.DmCod
        LEFT JOIN B01_JB01_R ON B01_JB04_R.Dmcod = B01_JB01_R.DmCod AND B01_JB01_R.NODEID=B01_JB04_R.NodeID
        INNER  JOIN B01 b02 ON ZB02_Hiber.DmCod = b02.B00;

这段语句执行之后提示转换错误  “消息 8169，级别 16，状态 2，第 1 行
将字符串转换为 uniqueidentifier 时失败。”

求各位大神帮忙解决下

uniqueidentifier 类型的值是通过newid()实现的。

您好，我是有问必答小助手，您的问题已经有小伙伴解答了，您看下是否解决，可以追评进行沟通哦~

如果有您比较满意的答案 / 帮您提供解决思路的答案，可以点击【采纳】按钮，给回答的小伙伴一些鼓励哦～～

ps:问答VIP仅需29元，即可享受5次/月 有问必答服务，了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632