You can't use a variable in the FROM clause.

However if this is for something like masking data on restores to dev/test, and isn't run often, you can use dynamic-SQL

declare @cmd...

Closing this thread.

Please post replies here: http://www.sqlservercentral.com/Forums/Topic1606742-3411-1.aspx

Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).

You don't want to do this in SQL Server. Use Windows at...

That's a...

Boy, I Miss Lucy, :-P:-P:-P:-P

I had fun trying to come up with plausible incorrect answers.

Developing and (some) testing against a subset doesn't mean that you never use production data, or even greater-than-production sized sets. It means that you do lots of your development against...

Finally, things are working. A debug item slipped through into production (apparently).

Let me know if things are still broken.

I see it. We'll review as soon as we can

Yep, reported and people are looking at it.

Either we had some injected code or someone deployed something they shouldn't have.

:(, you took away my pictures

Long week? :w00t:

The Fault (8/21/2014)

---

This is all "perfect world" stuff, but we don't live in a perfect world. Project managers and stakeholders simply won't accept or sanction delays of a few weeks...

kiwood (8/21/2014)

---

Lets just say that the developer may have said no bugs, but his users didn't. (Unless they "tested" using production data.) The other thing this tells me is that...

blah12345 83778 (8/20/2014)

---

I think the term bronze age development really does sum up writing t-SQL, there are some tools which are starting to emerge and get better but the tooling...

I see all but yours.

See attachment