<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.3790.2817" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=558464812-12022007><FONT face=Arial size=2>Our helpdesk is
going to implement a standard of making contact with the requestor within 30
minutes of the ticket being created. I need to write a query to find the
number of tickets that fall into that category for a given time period. I
know I'm looking for the time difference between the creation query and first
transaction on that ticket, but can't get the query right. </FONT></SPAN></DIV>
<DIV><SPAN class=558464812-12022007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=558464812-12022007><FONT face=Arial size=2>Any help would be
greatly appreciated. </FONT></SPAN></DIV></BODY></HTML>