advanced code snippet search

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.

Expand | Embed | Plain Text 
  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.