oops

Might be no column name for:

A.EndDate' + @SELECTFINAL

in:

SET @SQLCMD = 'SELECT SUM(A.AmountGiven) AS AmountGiven , A.year(startdate), A.EndDate' + @SELECTFINAL + ' FROM (' + @SQLCMD + ') A...

I'm not an expert in using CTEs, but I don't see how they would help here.

mqbk (8/13/2014)

---

I was hoping I could avoid a union but I guess it is unavoidable. Would a CTE be more effective?[/quote

How would you use a CTE to accomplish this?

What about:

[Code]

SELECT .... FROM Active_Table WHERE ......

UNION ALL

SELECT .... FROM Archive_Table WHERE ......

[/Code]

I think I found a way to make it work, but if you ask me, you seem to have a poor database design and a poor understanding of how the...

Am I missing something here? There's only 1 record in ST that matches the value in the where clause so you will only get 1 value for Stock.

The query...

Not much more we can do without the sample data and the query with query results for that sample data.

Did you replace the x's in the WHERE clause with a proper value?

Great. Now hope it never generates an email. 🙂

As I expected.

Change Dts.Variables["CareAlertLoadError"].Value = Dts.Variables["ErrorDescription"];

to Dts.Variables["CareAlertLoadError"].Value = Dts.Variables["ErrorDescription"].value;

You're trying to pass the whole variable object instead of just its value.

Can you show me the code that attempts to assign the message to the variable?

SQLRNNR (8/7/2014)

---

Not sure which application you are referring to, but...

If you were to be using an application such as Dynamix AX from MS, you either create the indexes from within...

SQLRNNR (8/7/2014)

---

Oh blocking, yeah that must have...

You can set restrictions on when it executes. What I've done before is check the length of the combined error messages. If the length was zero, then don't...