How to Count tickets as DateWise

Posted by user560716 on Stack Overflow See other posts from Stack Overflow or by user560716
Published on 2011-01-03T00:36:41Z Indexed on 2011/01/03 0:54 UTC
Read the original article Hit count: 130

Filed under:
|
|

I have a query regarding my report, the report format is as under

**Date**           **Received**        **Closed**        **Pending**  
12/01/10              1000                 900               100
12/02/10              2000                1000              1000
12/03/10              1500                1300               200

The above report shows the Help Desk tickets Received, Closed, Pending Count as date wise.

How can I create a dynamic SQL query to show above result?

  • Received Tickets is calculated on SubmitedDate
  • Closed Tickets is calculated on ClosedDate with status "Closed"
  • same for Pending Tickets whose status is "Pending".

Please provide me the idea or some sample SQL queries.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server