Viewing 15 posts - 6,526 through 6,540 (of 9,720 total)
The one sure way to avoid that is to use an IF EXISTS statement before creating your temp table. But you've already got a version of that. Did you remove...
February 9, 2011 at 12:32 pm
Post your new code. Include details on which code is in which task and tell us which of the tasks is failing.
February 9, 2011 at 12:24 pm
Remove your variable declarations. Remove the "Set @cmd1 = ' " bits and the trailing single quotes after the T-SQL. Remove the Execute statements.
Then run the code.
As Koen said, there's...
February 9, 2011 at 11:56 am
Koen (da-zero) (2/9/2011)
February 9, 2011 at 11:35 am
Gus's suggestion has me wondering if a book like that would actually sell.
February 9, 2011 at 10:52 am
Between @Cmd2 and @Cmd3, how are you populating the temp table?
Is it a separate task after executing @Cmd2 and before executing @Cmd3? Or are you doing it all in...
February 9, 2011 at 10:48 am
CirquedeSQLeil (2/9/2011)
Peter Trast (2/9/2011)
CirquedeSQLeil (2/9/2011)
HistogramHistamine
Histayours
OK, how about word morph? Each WOTD a morph of the last?
That game works well here.
And we've done it several times before. And will likely do...
February 9, 2011 at 10:42 am
Actually, I refer to CASE as a statement all the time. Call me lazy. I think I picked up the habit from the programming languages I learned in HS and...
February 9, 2011 at 10:40 am
Jan Van der Eecken (2/9/2011)
February 9, 2011 at 10:38 am
An additional note about SSIS, you can multicast the same data to do different destinations at the same time. That's one of the reasons why I like it for situations...
February 9, 2011 at 10:35 am
What is the error message? Please post it.
February 9, 2011 at 10:34 am
Dave Ballantyne (2/9/2011)
Handed my notice in today , i can already feel the freedom 🙂
Actually, that's just the wind blowing up your kilt. @=)
Seriously, though, are you just moving on...
February 9, 2011 at 9:13 am
I'm betting it's a QD problem. I've seen similar problems before and the query you presented us with looks exactly like it was "written" by Query Designer. QD just doesn't...
February 9, 2011 at 8:22 am
Are you seeing performance issues with any other processes, views, or queries?
EDIT: Are you using Query Designer?
February 9, 2011 at 8:10 am
Viewing 15 posts - 6,526 through 6,540 (of 9,720 total)