插入临时表时报在将 nvarchar 值 'config_category.metadata_item.popedom' 转换成数据类型 int 时失败

select  --2019 as iyear,
a.ywyid,d.name ywymc
--a.cpx,a.cpxmc --,CAST(ISNULL(g.rwe,'0') as varchar)
into ydbymbe_lt1
from 
(
    select a.ywyid,b.id cpx,b.showvalue cpxmc-- into aaa 
    from NSC_A8_renwufenjiecengji a 
    left join NSC_A8_changpinxian b on  1=1
) a 
left join  mbe_lt201911411411140 c on c.ywyid = a.ywyid and c.cpxmc = a.cpxmc 
left join 
(
        select d.iyear,d.ywyid,d.cpxmc,cast(sum(isnull(d.rwe,0)) as money) rwe from(
        select a.iyear,a.ywyid,isnull(c.showvalue,'') xzyf,isnull(b.cpx,'') cpxmc, b.je rwe from NSC_A8_yiqixiaoshoujihuashenqingzb  a 
        left join  NSC_A8_yiqixiaoshoujihuashenqingmx b on a.id = b.formmain_id  
        left join NSC_A8_xinzengshijian c on c.id = b.xzsj
        where c.showvalue<= 9 
        )d   group by d.iyear,d.ywyid,d.cpxmc
)g  on g.ywyid = a.ywyid and g.cpxmc = a.cpxmc 
left join  NSC_A8_member_department d on d.id = a.ywyid

利用排除法  确定 d.name 这个字段出现时报这个错误，有可能 和关联

left join  NSC_A8_member_department d on d.id = a.ywyid
有关

NSC_A8_member_department   ID字段是bigint 类型

NSC_A8_renwufenjiecengji   ywyid字段是varchar 类型

两个字段类型不同导致错误

修改NSC_A8_renwufenjiecengji ywyid数据类型后，解决报错问题

select 
field0001 ywybm,    --业务员编码         
CAST(field0002 as bigint) ywyID,    --业务员名称         
field0003 zgbm,         --主管编码         
field0004 zgmc,         --主管名称    
field0005 jlbm,         --经理编码     
field0006 jlmc,         --经理名称         
field0007 fzbm,         --副总编码         
field0008 fzmc,          --副总名称         
field0009 zjlbm,    --总经理编码     
field0010    zjlmc,     --总经理名称         
field0011    bmbm,     --部门编码         
field0012    bmmc    --部门名称    
from      OA70.dbo.formmain_0061