Viewing 15 posts - 13,441 through 13,455 (of 18,923 total)
Actually it's "WITH RECOMPILE"
September 8, 2005 at 7:34 am
You forgot one.. are ou using the same set of parameters for both procs?
September 8, 2005 at 7:07 am
I'll keep using my dts task... far less complicated
.
September 8, 2005 at 6:35 am
Dude it's just not the way to program in sql, you relly need to get aquinaed with these article.
September 8, 2005 at 6:30 am
Create a local copy of all the parameters used in the query, copy the parameters' value to the local variables and use those variables in the query.
You can search for...
September 7, 2005 at 10:14 pm
Check out the script section, a much more complete script could do all those operations and much more.
September 7, 2005 at 10:10 pm
You also need to learn sql programming. This is basically the worst possible way to use sql server's stored proc. You need to create one statement for each...
September 7, 2005 at 10:08 pm
SysIndexes are not reliable, those stats are not always up to date. Count(*) is the only safe solution for this problem if accuracy is required.
September 7, 2005 at 10:06 pm
Do the whole thing in dyn sql..
can you post your current code?
September 7, 2005 at 2:55 pm
Still requires 2 passes, and there's no way around that.
September 7, 2005 at 2:42 pm
DLL problem is either a bug or a bad driver version. Reinstall might take care of it.
September 7, 2005 at 2:08 pm
Did you try reinstalling the sql server objects (qa, em...).
September 7, 2005 at 2:01 pm
Viewing 15 posts - 13,441 through 13,455 (of 18,923 total)