SELECT TOP 30000
Replace (replace (T1. Receivername,char (Ten), '), CHAR (+), ') as Receivername,
Replace (replace (Receivercompany,char (), '), CHAR (+), ') as Receivercompany,
Replace (replace (T1. Receiverphone,char (Ten), '), CHAR (+), ') as Receiverphone,
Replace (replace (T1. Receivercity,char (Ten), '), CHAR (+), ') as Receivercity,
Replace (replace (T1. Receiverzipcode,char (Ten), '), CHAR (+), ') as Receiverzipcode,
Replace (replace (T1. Receiverstate,char (Ten), '), CHAR (+), ') as Receiverstate,
Case when T2. Chinesename= ' Germany ' then 1
When T2. Chinesename= ' Italy ' then 2
When T2. Chinesename= ' France ' then 3
When T2. Chinesename= ' Russia ' then 4
When T2. Chinesename= ' UK ' then 5
When T2. Chinesename= ' America ' then 6
When T2. Chinesename= ' Australia ' then 7
When T2. Chinesename= ' Brazil ' then 8
When T2. Chinesename= ' Chile ' then 9
When T2. Chinesename= ' Israel ' then 10
When T2. Chinesename= ' Holland ' then 11
When T2. Chinesename= ' Spain ' then 12
When T2. Chinesename= ' Canada ' then 13
END as Continent
From Logistics.express T0 INNER joins Logistics.expresscustomforru T1 on T0. Waybillnumber = T1. Waybillnumber
INNER JOIN basicsetup.region T2 on T0. RegionID = T2. Id
INNER join [Humanresource]. [Company] T3 on T0.companyid=t3.id
where T0. channelid=131 or T0. channelid=132
Excel replication SQL query Results misplaced