22,209
社区成员
发帖
与我相关
我的任务
分享
insert into [CIDWSD].[dbo].[OrganizationalContact]
SELECT [PhoneNumberID]=cast(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(substring([电话1],2,LEN([电话1])),'0','0')
,'1','1')
,'2','2')
,'3','3')
,'4','4')
,'5','5')
,'6','6')
,'7','7')
,'8','8')
,'9','9')
,'-','-')
as varchar(12))
,[OrganizationID]=[ORG_Code]
,[ExtensionNumber]=''
,[Type]=''
,[Department]=''
,[LinkMan]=''
,[Position]=''
,[Memo]=''
,[CreateTime]=GETDATE()
,[Creator]='dbo'
,[EditTime]=GETDATE()
,[Editor]='dbo'
FROM [CIDWSD].[dbo].[OrganizationsContact2011-01-20]
where [ORG_Code] not in(select [OrganizationID] from [CIDWSD].[dbo].[OrganizationalContact])
and [电话1] is not null and [电话1] <>''
and cast(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(substring([电话1],2,LEN([电话1])),'0','0')
,'1','1')
,'2','2')
,'3','3')
,'4','4')
,'5','5')
,'6','6')
,'7','7')
,'8','8')
,'9','9')
,'-','-')
as varchar(12))
not in (select [PhoneNumberID] from [CIDWSD].[dbo].[OrganizationalContact])
and [ORG_Code] in (select [OrganizationID] from [CIDWSD].[dbo].[Organization])
[PhoneNumberID]=cast(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(substring([电话1],2,LEN([电话1])),'0','0')
,'1','1')
,'2','2')
,'3','3')
,'4','4')
,'5','5')
,'6','6')
,'7','7')
,'8','8')
,'9','9')
,'-','-')
as varchar(12))