Viewing 15 posts - 451 through 465 (of 3,232 total)
Why can't the 2 temp tables be JOINed? Did you try Wayne's code?
What is the difference between JOINing the tables together to produce the output and using the ID...
June 4, 2010 at 9:25 am
It looks like what Wayne provided will work for you, but seeing your SP code brings up another question. It appears that you've changed some things "to protect the...
June 4, 2010 at 8:12 am
Glad to hear that you are working. If you decide to re-write the cursor (it will perform much, much better) than post your code and we'll help out.
June 3, 2010 at 10:15 am
Yes, it is possible. You can have several temp tables within the same stored procedure and it should function just fine.
Your issues probably have more to do...
June 3, 2010 at 8:59 am
In addition to what Bhuvnesh has requested, please post your update logic as well. So one row at a time; are you using a cursor?
June 2, 2010 at 7:57 am
How big is the table and what how many rows are you trying to update?
June 1, 2010 at 3:59 pm
Lynn Pettis (5/28/2010)
crookj (5/28/2010)
Freedom (It is Memorial Weekend for us in the U.S.)Rembember to give a moment of thought and thanks to those who gave their all for our Country.
Joe
We...
May 28, 2010 at 10:03 am
Since this is your first post, I'll fill you in on a bit of forum best practices. It helps us a bunch if you post example DDL, data, and...
May 27, 2010 at 10:31 am
Chris Morris-439714 (5/21/2010)
John Rowan (5/21/2010)
Chris Morris-439714 (5/21/2010)
John Rowan (5/20/2010)
I have 5 kids under the age of 10I reckon we should all club together and buy John a telly.
Telly?
Something else...
May 21, 2010 at 8:31 am
Viewing 15 posts - 451 through 465 (of 3,232 total)