select aa.PSCode, aa.RegionName,aa.PSName,aa.CorporationCode,aa.CommunicateAddr,aa.Linkman,null ContractID into #bankcontract from (select b.PSCode,a.RegionName, b.PSName, b.CorporationCode, b.CommunicateAddr, b.Linkman from Dictionary.Region a , PSInfo.PSBaseInfo b where a.RegionCode = b.RegionCode and b.DeleteFlag = 0 and b.Status = 0 and b.RegionCode=330109000) aa红字的地方把类型隐式转换了
into #bankcontract
from
(select b.PSCode,a.RegionName, b.PSName, b.CorporationCode, b.CommunicateAddr, b.Linkman
from Dictionary.Region a , PSInfo.PSBaseInfo b
where a.RegionCode = b.RegionCode and b.DeleteFlag = 0 and b.Status = 0 and b.RegionCode=330109000) aa红字的地方把类型隐式转换了