SQL Server Performance Forum – Threads Archive

Optimize Stored Procedure

This one is for the Gurus.
I have a Stored Proc which has nested Sp’s.Is there a way that i can write this in one sp in a transaction Block.As per the requirement i need to avoid Cursors and possibley not use temp tables.I am not a techi but have been assigned this. I have pasted all the nested sp’s in order of there execution . Please help? ::Refer to the following Sp’s in my next reply As I had no response i have deleted the stored proc
Thanks

---

This is one of the longest procedures I’ve seen so far. As this is hard to follow can you break down it into parts? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

---

EasySQL, can you highlight the changes you made? Madhivanan Failing to plan is Planning to fail

---

]]>