
update dbo.tab_grade_ddz set id = 12534 where id = 2534 and serialNumber = '091';
update dbo.tab_grade_ddz set id = 12652 where id = 2652 and serialNumber = '277';
truncate table show_results_bov;
INSERT INTO show_results_bov (
	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_bob,
	result_bow,
	result_wb,
	result_biss,
	rankings,
	formatCode,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	'',
	showsId,
	judges,
	breedId,
	breedIdOther,
	showsPlace,
	dogGroup,
	ageClass,
	dogSex,
	fciCode,
	UserName_C,
	UserName_E,
	userId,
	integrals,
	serialNumber,
	CC,
	CC_Remarks,
	BOB,
	BOW,
	WB,
	BISS,
	rankings,
	formatCode,
	1 create_by,
	SYSDATE() create_date,
	1 update_by,
	editTime,
	Remarks,
	del_tag
FROM
	dbo.tab_grade_ddz;

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

update show_results_bov set del_flag = 0 where del_flag is null;