truncate table show_main;


INSERT INTO show_main(
	id,
	show_location,
	main_show_name,
	closing_time,
	organizer,
	referee,
	register,
	orgnize_type,
	dog_num_max,
	branch_show_detail,
	show_cancel,
	venues_id,
	attention,
	isTop,
	start_time,
	end_time,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	min(id),
	赛事地点,
	min(赛事名称),
	min(cku_endtime),
	min(organizer),
	min(cku_caipanid),
	max(赛事报名),
	max(gameType),
	max(top_dog),
	min(shows_detail),
	min(showCancel),
	max(venue_id),
	min(attention),
	max(isTop),
	min(开始日期),
	max(结束日期),
	1,
	max(添加日期),
	1,
	max(修改日期),
	'',
	max(del_tag)
FROM dbo.tab_games group by 赛事地点;





update show_main set del_flag = 0 where del_flag is null;

update show_main set orgnize_type = 1 where orgnize_type ='自办';
update show_main set orgnize_type = 0 where orgnize_type ='合办';

update show_main set organizer = 1 where organizer ='北京';
update show_main set organizer = 2 where organizer ='杭州';
update show_main set organizer = 3 where organizer ='长春';