use   Êý¾Ý¿âÃû
insert into sp_t_item_info(item_no,item_name,item_size,item_class,item_unit,supcust_no,item_product_area,quality_day,item_produce_no) 
 select  distinct item_subno,item_name,item_size,item_clsno,unit_no,sup_no,product_area,valid_days,product_supno  
 from  bi_t_item_info
  where item_subno not in (select item_no from sp_t_item_info) and len(item_subno)>0 and item_no in (
	select t1.item_no from (
				select min(item_no) item_no ,item_subno from bi_t_item_info where item_subno in 
					(select  item_subno from  bi_t_item_info where len(item_subno)>0 group by item_subno)
				group by item_subno
			) t1 )