select @cnt = count(1) from pm_volcurves_histdata

while ( @cnt>0 )
begin
  begin
        begin tran
        set rowcount 40000
			
      /* Get batch of 40000 records from pm_volcurves_histdata into  #temp_pm_volcurves_data */
	select curve_id, commodity, currency, rundate, term, strike, volatility
	into #temp_pm_volcurves_data
	from pm_volcurves_histdata
				
	create index #temp_pm_volcurves_data_idx on #temp_pm_volcurves_data(rundate, curve_id)
			
		
	/* Delete the batch of 40000 records that we got into #temp_pm_volcurves_data from pm_volcurves_histdata */
	delete from pm_volcurves_histdata
			
	set rowcount 0
        commit tran
  end

begin tran
		
  /* Insert the curve if it is not present in pm_volcurves table */
      insert into pm_volcurves (curve_id,commodity, currency)
      select distinct curve_id, commodity, currency  from #temp_pm_volcurves_data a	
      where not exists (select b.curve_id from pm_volcurves b where b.curve_id=a.curve_id)

  /* Insert the data into pm_volcurves_data table */
      insert into pm_volcurves_data(sequence_no, rundate, term,strike, volatility )
      select b.sequence_no, a****ndndate, a.term, a.strike, a.volatility 
      from #temp_pm_volcurves_data a, pm_volcurves b 
      where a.curve_id=b.curve_id
			
   commit tran

drop table #temp_pm_volcurves_data
select @cnt=count(1) from pm_volcurves_histdata
end