Insert Into "\Memory\Mapping86_1"
(Destinationid,Destination,Dialcode,
  Carrier_Dest,Carrier_Code,Timezone,Tzidentified,
  price1,price2,price3,orgwhrg,orgprice1,orgprice2,orgprice3,
  bill_int1,bill_int2,
  info1,info2,info3,identrun,Validon)
Select
   D.Destinationid,D.Destination,D.Dialcode,
   R.destination,R.Code,R.tzcarrier,R.tzidentified,
   R.preis,R.preis2,R.preis3,R.orgwhrg,R.orgpreis,R.orgpreis2,R.orgpreis3,
   R.Bill_Intervall1,R.Bill_Intervall2,
   R.Info1,R.Info2,R.Info3,2,Cast('2013-04-01' as Date)
  from
   "D:\Databases\D2010\mtcarrierdb_5001_11\MasterData_DB\RC_MasterData86" R inner oin "D:\Databases\D2010\mtcarrierdb_5001_11\Dest_Prot" D on
   D.Dialcode = left(R.Code,length(R.Code)-20)
  WHERE
   (Cast('2013-04-01' as Date) >= R.Gueltigab and (Cast('2013-04-01' as Date) < R.Gueltigbis or R.Gueltigbis is Null)) and
   R.tzcarrier = 3 and
   (Cast('2013-04-01' as Date) >= D.Validfrom and Cast('2013-04-01' as Date) < D.ValidUntil)
   and
   R.Code not in (Select Carrier_Code from "\Memory\Mapping86_1" WHERE Timezone = 3)
JoinOptimizeCosts;