问存储过程中的多列计数

EN

ALTER procedure [dbo].[Driverperformance]
@code nvarchar(50),  
@startdate datetime, 
@enddate datetime,
@test VARCHAR(1)
as   

IF @test = 1 BEGIN
    SELECT  e.Ecode, CAST(q.dtime AS DATE) as Date ,  e.Ename,  count(q.Ecode) CntEcode 
    FROM EmployeeMaster_tbl e 
    JOIN Transaction_tbl q  
    ON e.Ecode = q.Ecode     
    where q.Ecode=@code and dtime >= '' + @startdate +'' and dtime <= ''+@enddate +''
    group by e.Ecode, e.Ename, CAST(q.dtime AS date) 
    ORDER BY CAST(q.dtime AS date)--e.Ecode DESC
    END
ELSE
    BEGIN

    SELECT  e.delEcode, CAST(q.dtime AS DATE) as Date ,  e.Ename,  count(q.delEcode) Cntcode 
    FROM EmployeeMaster_tbl e 
    JOIN Transaction_tbl q  
    ON e.delEcode = q.delEcode     
    where q.delEcode=@code and dtime >= '' + @startdate +'' and dtime <= ''+@enddate +''
    group by e.delEcode, e.Ename, CAST(q.dtime AS date) 
    ORDER BY CAST(q.dtime AS date)--e.Ecode DESC
    END
END

ALTER procedure [dbo].[Driverperformance]
@Ecode nvarchar(50),  
@startdate datetime, 
@enddate datetime,
@test bit=0  
as   begin   

SELECT  e.Ecode, CAST(q.dtime AS DATE) as Date ,  e.Ename,  case when @test=1 then count(q.Ecode) else count(q.delCode) end as CntEcode 
FROM EmployeeMaster_tbl e 
JOIN Transaction_tbl q  
ON e.Ecode = q.Ecode     

where q.Ecode=@Ecode and dtime >= '' + @startdate +'' and dtime <= ''+@enddate +''

group by e.Ecode, e.Ename, CAST(q.dtime AS date) 

ORDER BY CAST(q.dtime AS date)--e.Ecode DESC

end