Thanks Paul

Thanks, but if the records are keep on updating, so I will end up in 100s of records for the same Account in the same table and its too difficult...

Thank you all. I will go will the row_id for each positiion and join it to the both columns

Thanks

I have the similiar issue . Is there a solution for this output clause or some other clause instead of looping through using cursor

Thanks,

Is there any third party tools similiar to Report builder to generate Ad-hoc reports. ?

Thank you again

Matt.