>Can you please be more detailed on the relationship within the table. This type of ordering is usually easily accomplished with a simple group and partition by but the details are not jumping out at us. It almost seems like there is a missing key for the relationship unless your results are just varying all over.
Ted,
Thanks a lot for your help!
If it's not broken, fix it until it is.
My Blog