Thanks for the reply,

Yes i am taking the sum of flt_amount field based on the transcode in the int_transcode

if the Transcode='TR001' then i need to add float_amount,

it goes upto Transcode='TR008' like eight conditions and i want to return eight out put from the procedure, i dont know how to do it please help me guys.

Thanks