SQL Query
I am writing some web pages to generates reports and graphs. I ran my query on the sql server and came back with 97 opened tickets so far this month. I then go to the help desk and create a custom view to show all tickets for the month of march. The helpdesk returns 48. I checked the workorderd from the first helpdesk ticket (15573) and the last (15674). If I query all requests between these two ids I get 97. If I create a custom view on the helpdesk and show all tickets within that range of id's I get 48. Is there something I am missing? Any help is appreciated.
Thanks
Rick
Thanks
Rick