sql-oholic (3/5/2009)
Its really long code .. approx 400 lines.I was hoping to get some tips & tricks .. best practices when using temp tables in sproc
Save it as a file and attach it to the thread (there's an option for "Edit Attachments" when you post a message). A 400-line proc generally isn't that big a deal, so long as it's reasonably well formatted.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon