The missing table is caused by a flaw in your Coalesce statement when you assign a value to @TableList.

Try this in a proof-of-concept database:

CREATE TABLE tmp1 (

C INT);

GO

CREATE TABLE tmp2...

ChrisM@Work (7/10/2012)

---

Jeff Moden (7/9/2012)

---

In 2008 or less, I'd REALLY like to know how to create a view that does a running total without forming a Triangular Join. I don't...

You can use VB expressions in SSRS Report Builder. Samples here: http://technet.microsoft.com/en-us/library/ms157328.aspx#VisualBasicFunctions

I don't remember VB well enough to build the expression myself, but what you need to do is:

1....

Yep.

(Wouldn't go so far as to call it my way. More like Codd's and Date's way....

Data analysis is its own science, with its own complexities, and very, very few people are educated and trained in it, and most of those are in the Intelligence field....

David McKinney (7/10/2012)

---

J Livingston SQL (7/9/2012)

---

Andy Hyslop (7/9/2012)

---

It's a little extra work, but I always try to add a new column 'in the right place' where applicable. I concede that...

SQLKnowItAll (7/9/2012)

---

Jeff Moden (7/9/2012)

---

In 2008 or less, I'd REALLY like to know how to create a view that does a running total without forming a Triangular Join. I don't...

Very true.

Plenty, if I'm not mistaken. Linked servers, SSIS, other ETL tools, even OpenQuery, should all work. Found an ODBC driver for MySQL in a simple Bing search (Google...

That's the same solution...

Not Exists is usually faster, and has the advantage that you can use multiple columns in it for the validation. Not In is usually better for hard-coded sets of...

At a place I used to work, the IS manager (who was the DBA before they hired me) had a policy that every table had to have an ID column...

Are you using triggers for the audit, or something else?

If you are using triggers, can you add "IF HOST_NAME() != 'MyWebServer' RETURN;" at the beggining of the trigger? (With,...

I've had hybrid solutions for that kind of thing.

Read today's data and perform on-the-fly calculations (running totals, running averages, et al) on that.

ETL data prior to today and store pre-calculated...

I've also had to pre-calculate data like running totals, running averages, and so on, in data warehouses populated by scheduled ETL processes. After all, that's a large part of...