从查询结果中查询数据

1、按照日期、客户、人员编号、姓名查询不重复的记录

select distinct left(convert(varchar(20),dt_ReceiveTime,120),10) AS dt_ReceiveTime, 
vc_CustomerName AS vc_CustomerName,vc_EmployeeName AS vc_EmployeeName,vc_EmployNo AS vc_EmployNo from SMS_DateReport

2、从第一步不重复的记录里面计算出 出差天数及人数，按照客户分组

select distinct T.vc_CustomerName AS 客户名称,
count(left(convert(varchar(20),T.dt_ReceiveTime,120),10)) AS 出差天数,
COUNT (distinct T.vc_EmployNo) AS 出差人数
from 
(select distinct left(convert(varchar(20),dt_ReceiveTime,120),10) AS dt_ReceiveTime, 
vc_CustomerName AS vc_CustomerName,vc_EmployeeName AS vc_EmployeeName,vc_EmployNo AS vc_EmployNo from SMS_DateReport)T

group by T.vc_CustomerName

.