title: count of multiple columns in stored procedure
body: <p><img src="https://i.stack.imgur.com/corVB.png" alt="enter image description here"> My stored procedure like this:</p>
  
  <pre><code>ALTER procedure [dbo].[Driverperformance]
  @Ecode nvarchar(50),  
  @startdate datetime, 
  @enddate datetime  
  as   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=@Ecode and dtime &gt;= '' + @startdate +'' and dtime &lt;= ''+@enddate +''
  
  group by e.Ecode, e.Ename, CAST(q.dtime AS date) 
  
  ORDER BY CAST(q.dtime AS date)--e.Ecode DESC
  
  end
  </code></pre>
  
  <p>this is working fine.in this i am getting count of [(q.Ecode)] is perferct.i have one more field in transactiontable name(DelEcode).i want to take count of(DelEcode) the same way.sam way means how i am taking count of Ecode like that i have to take count of DelEcode aslos.so what the changes i have to make in my current stored procedure..while executing am getting out put like this: but i want to get one more column cntDelcode in that i want to show count of DelEcode</p>