I have an SQL database which is the backend for my helpdesk system.
I need to do some reporting and need some advice.
I have a report which will take data from various tables.
I have created a query to show the following
This returns a number of rows similar to the info below
and so on. . . .
I want the query to return a sum for each TICKET_ID such as..
You advice on how to do this is apprciated.