declare @P1 int,@currIndex int;declare @sql varchar(4000),@sql1 varchar(2000),@sql2 varchar(2000);declare @data table(record_id int);set @sql1 = 'select record_id from demo as t1 where 1=1 and

update sys_ycl_local_skill s1set xhsl = (  with tp1 as (  select t2.md005,  (select count(1) from sys_yclbom t4 where t4.s_barcode = t3.bc_code) num,  t3.bc_code  from sys_cx_model_mach t1