donato1026 (4/7/2009)
Like I said... Being new at this, I am not sure what the best way is to do this. I just know it runs VERY slow. A little over 11 minutes for 27 rows. :-/I appreciate all of your help.
I just want to know the best way to do it, and honestly, I am still learning all the lingo.
Thanks!
Trust me, we totally understand where you're coming from. Everyone has to start somewhere if they want to get anywhere.
Just let us know as you come across stuff you don't understand in what we're posting, and we can help you figure it out.
If you can, posting the table definitions and some sample data, will greatly help us to help you. I started rewriting the proc, but I'm running into the problem of not being able to test my code.
- 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