create proc proc_test
(
@部门 varchar(10),
@开始时间 datetime,
@结束时间 datetime
) 
as
begin
    select a. 部门,a.姓名,
            [客户更新量] = (select count(1) from 客户表 where 更新日期 between @开始时间 and @结束时间 and 关联 = a.关联),
            [客户增量]   = (select count(1) from 客户表 where 更新日期 < @开始时间 and 关联 = a.关联),
            [潜在客户更新量] = (select count(1) from 潜在客户表 where 潜在更新日期 between @开始时间 and @结束时间 and 关联 = a.关联),
            [潜在客户增量]   = (select count(1) from 潜在客户表 where where