truncate table show_results;
INSERT INTO show_results (
	id,
	dog_id,
	show_code,
	referee,
	pedigree_certified,
	other_certified,
	race_lap,
	dog_breed_group,
	age_group,
	dog_gender,
	fci_code,
	dog_owner_name_cn,
	dog_owner_name_en,
	dog_owner_member_code,
	show_result,
	order_code,
	result_cc,
	remarks_cc,
	result_cacib,
	remarks_cacib,
	result_bob,
	result_bis,
	result_big,
	result_bow,
	result_wb,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
)   SELECT
	id,
	'',
	赛事编号,
	裁判,
	血统证书号,
	其他证书号,
	赛圈,
	犬种组,
	年龄组别,
	性别,
	FCI代码,
	犬主中文名,
	犬主英文名,
	会员号,
	本场积分,
	秩序号,
	CC,
	CC_Remarks,
	CACIB,
	CACIB_Remarks,
	BOB,
	BIS,
	BIG,
	BOW,
	WB,
	1 create_by,
	SYSDATE() create_date,
	1 update_by,
	修改日期,
	Remarks,
	del_tag
FROM
	dbo.tab_grade;



update show_results set dog_gender = 1 where dog_gender = '公';
update show_results set dog_gender = 2 where dog_gender = '母';

update show_results set del_flag = 0 where del_flag is null;

