Posted By

ChristineFM on 03/13/12


Tagged

sqldatabasesupport


Versions (?)

On Call Statistics


 / Published in: SQL
 

Retrieves a list of "on call" incidents for the most recent time period. Selects all Support Analysts.

  1. SELECT *
  2. FROM dbo.OnCall_stats
  3. WHERE Chargeable = 'yes'
  4. AND paid = '0'
  5. ORDER BY Entry_Date DESC

Report this snippet  

You need to login to post a comment.