sqlserver有条件的insert

insert into plc_caijidian (objuid,chang_id,gong_dan_hao, cj_shujv,chuangjianshijian, chuangjianren,chan_xian,tiao_ma,gong_xv)
select 20201214+row_number() over (order by tiao_ma) as rowid,‘JBJH’,‘MZ202012140010001’, ‘[
{
“B037.50.D1086”: “200”,
“B037.50.D1084”: “3000”,
“B037.50.D1090”: “2880”,
“B037.50.D1082”: “200”,
“B037.50.D1092”: “589”
}
]’, getdate(),‘PLC_NEW_H4’,‘B037’,tiao_ma,‘50’ from plc_caijidian where gong_dan_hao = ‘MZ202012140010001’ and gong_xv=‘10’