porcelain

Jack Corbett (2/9/2011)

---

GSquared (2/9/2011)

---

Jack Corbett (2/9/2011)

---

I probably wouldn't use a view because I like to use SP's for all data access so the query would just go in the SP...

Ninja's_RGR'us (2/10/2011)

---

kasaranenikiran-725528 (2/10/2011)

---

This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also look in to putting it in...

Oh, that sounds interesting. I'll have to...

GSquared (2/9/2011)

---

And to those in Florida who can't deal with frigid, sub-70...

So we can see what you've done, please post your solution to your other problem.

There are several ways to solve your second problem. Because we're trying to help you learn...

Koen, don't bait. You know better.

nadabadan, please remember this is a professional forum. You may not realize this, but your written word choices come off as defensive and argumentative, without...

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...

Post your new code. Include details on which code is in which task and tell us which of the tasks is failing.

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...

Koen (da-zero) (2/9/2011)

---

Furthermore, it is possible that the statement within the EXEC is executed under a different scope, so your temp table is likely already destroyed before the next statement...

Gus's suggestion has me wondering if a book like that would actually sell.

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...

And we've done it several times before. And will likely do...

Diagram