Viewing 5 posts - 16 through 20 (of 20 total)
Thanks, that did it.
So in the end the QUpdate is about 75% faster than the Cursor. So far my worst case cursors are only taking a couple minutes (there...
May 13, 2010 at 11:50 am
Ok so everything is working... almost. The first problem I am running into is that I need to reset some values when an asset changes. Should make more...
May 13, 2010 at 7:39 am
Thanks for the replies, I will look into the "quirky update" method as a possible solution. The calculations are more involved than simple summing but I think it may...
May 11, 2010 at 7:28 pm
Thanks for the reply. The only problem with using temps is that they would need to be global or declared directly in temp database like you said. This...
May 10, 2010 at 8:26 am
I like the tool, however is there anyway to have it return rows? I have a need to execute multiple sprocs in parallel but these procs return result sets...
May 7, 2010 at 12:20 pm
Viewing 5 posts - 16 through 20 (of 20 total)