In our work order system we have service levels that we must meet. One of the service levels is how long a call is open before it is assigned to...

Just wanted to let you know we did implement this into our work order time tracking reports. It works GREAT!!!

This seems to work GREAT!!! Thanks so much for your help. It really helps to have someone else to look at your code, so thanks for doing my proofreading for...

That is cool! I am looking at where I modified the code and that is where SQL is throwing the error. Just not smart enough to determine exactly what is...

Hmmmm, I must be doing something wrong then, as the code you have described is exactly what I am doing. Initially I was using a view and passing these parameters...

Mazharuddin Ehsan (12/28/2007)

---

Incidently, I am also using this solution to calculate and report the duration passed for the unresolved IT HelpDesk cases at my work place. The results are displayed...

VERY COOL. We needed to be able to calculate time between the creation date of a help ticket and the time it was first modified. Without being able to take...