数据刷表

规格型号

合并成一个字段 规格@型号

数据库选择AIS20230131214054

select a.FMATERIALID,FNUMBER, F_QINL_OQGG 规格 ,FSPECIFICATION 规格型号,FSPECIFICATIONGG 规格废弃 ,F_QINL_SPECIFICATION 型号
from t_bd_material  a
left join T_BD_MATERIAL_L b 
on a.FMASTERID = b.FMATERIALID

F_QINL_OQGG + @ + F_QINL_SPECIFICATION = FSPECIFICATION
其中 FSPECIFICATIONGG 自定义（已经废弃）

update T_BD_MATERIAL_L
set FSPECIFICATION = F_QINL_SPECIFICATION+ '@' + F_QINL_OQGG
where FMATERIALID = 162518

异常对不上的

select 
	a.FMATERIALID,FNUMBER 物料代码  ,F_QINL_SPECIFICATION 型号
	, b.F_QINL_OQGG 规格 ,b.FSPECIFICATION 规格型号,   F_QINL_SPECIFICATION + '@' +  F_QINL_OQGG as 拼接
	,FSPECIFICATIONGG 规格废弃
from t_bd_material  a
	left join T_BD_MATERIAL_L b on a.FMASTERID = b.FMATERIALID
where
	FNUMBER='5.01.17.0242' and
	FSPECIFICATION !=  F_QINL_SPECIFICATION + '@' +  F_QINL_OQGG
	 
 

刷新异常数据

select 
b.F_QINL_SPECIFICATION 型号  ,b.F_QINL_OQGG 规格 ,b.FSPECIFICATION 规格型号,   F_QINL_SPECIFICATION + '@' +  F_QINL_OQGG as 拼接
from T_BD_MATERIAL_L  b
where b. FSPECIFICATION !=  b.F_QINL_SPECIFICATION + '@' +  b.F_QINL_OQGG 

update b
set b.FSPECIFICATION = b.F_QINL_SPECIFICATION+ '@' + b.F_QINL_OQGG
from T_BD_MATERIAL_L  b
where b. FSPECIFICATION !=  b.F_QINL_SPECIFICATION + '@' +  b.F_QINL_OQGG