Weston, Craig (OFT) wrote:
> 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?
>

What is the query used for that result?

brian