Baron, thank you for your response.
I did get a different result for the query:
18184639,12544976,0,0,0,0,0,0,0,0,0,0,0,0
But it still is "all" the data for the ticket in the row.
If I group by the ticket (key) number and the status, I get one line per
status with the "right" numbers.
18184639,240,0,0,0,0,0,0,0,0,0,0,0,0
18184639,0,81360,0,0,0,0,0,0,0,0,0,0,0
18184639,0,0,10680,0,0,0,0,0,0,0,0,0,0
18184639,0,0,0,0,0,0,0,0,38280,0,0,0,0
18184639,0,0,0,6480,0,0,0,0,0,0,0,0,0
18184639,0,0,0,0,0,0,0,8040,0,0,0,0,0
18184639,0,0,0,0,0,0,12081596,0,0,0,0,0,0
18184639,0,0,0,0,0,0,0,0,0,139920,0,0,0
18184639,0,0,0,0,16080,0,0,0,0,0,0,0,0
Can you think of some way to get these numbers on to one row?