create proc test
as
begin
update A
set A.name= B.UserName
from DataSource A inner join CompanyUserInfo B on A.CallNumber=B.CallNumber
update A
set A.name= B.UserName
from DataSourceTotal A inner join CompanyUserInfo B on A.CallNumber=B.CallNumber
end
as
begin
update A
set A.name= B.UserName
from DataSource A inner join CompanyUserInfo B on A.CallNumber=B.CallNumber
update A
set A.name= B.UserName
from DataSourceTotal A inner join CompanyUserInfo B on A.CallNumber=B.CallNumber
end
a) sp_GetDayCompanyData:计算公司员工日数据
对DataSource表的每一条记录,如果手机号码是公司员工的手机号码,那么更新“name”字段--存储过程可以这样写
create proc sp_GetDayCompanyData
as
update DataSource set name=a.UserName
from DataSource a inner join CompanyUserInfo on a.CallNumber=b.CallNumberb) sp_GetTotalCompanyData:计算公司员工周累计数据
对DataSourceTotal表的每一条记录,如果手机号码是公司员工的手机号码,那么更新“name”字段 --存储过程可以这样写
create proc sp_GetTotalCompanyData
as
update DataSourceTotal set name=a.UserName
from DataSource a inner join CompanyUserInfo on a.CallNumber=b.CallNumber