I wonder if you application is using cursors.

How do i fix my code?

Jeff,

They just asked me to performance tune it.

But it appears the SP insert data if (party_data) > 36. Then it adds up a sort_order, and for new instrument_id the sort_order...

go some data

Party table

-----------------------------------------

instrument_id party_id last_name first_name middle_name name_suffix

31966558329324CLUBBSTACYL

331891810350608CROOKE,BESSIE J EST

331891810350858JACKSONLLOYDD

output

-------------------

instrument_idparty_idsort_orderparty_data

319665583293241(I) CLUBB, STACY L

3318918103506082(I) CROOKE,BESSIE J EST

3318918103508583(I) JACKSON, LLOYD D