Viewing 15 posts - 991 through 1,005 (of 3,666 total)
oops
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 15, 2014 at 1:58 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 15, 2014 at 12:38 pm
I'm not an expert in using CTEs, but I don't see how they would help here.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 13, 2014 at 2:27 pm
mqbk (8/13/2014)
How would you use a CTE to accomplish this?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 13, 2014 at 2:00 pm
What about:
[Code]
SELECT .... FROM Active_Table WHERE ......
UNION ALL
SELECT .... FROM Archive_Table WHERE ......
[/Code]
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 13, 2014 at 1:56 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 13, 2014 at 1:29 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 13, 2014 at 1:14 pm
djj (8/13/2014)
Sample table data would be of help
Not much more we can do without the sample data and the query with query results for that sample data.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 13, 2014 at 12:25 pm
carlos cachulo-318532 (8/13/2014)
thanks for the quick reply, unfortenly the query you sent don´t return any result
Did you replace the x's in the WHERE clause with a proper value?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 13, 2014 at 12:15 pm
Great. Now hope it never generates an email. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 12, 2014 at 8:04 am
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.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 12, 2014 at 7:42 am
Can you show me the code that attempts to assign the message to the variable?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 12, 2014 at 7:31 am
SQLRNNR (8/7/2014)
If you were to be using an application such as Dynamix AX from MS, you either create the indexes from within...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 7, 2014 at 3:46 pm
SQLRNNR (8/7/2014)
GilaMonster (8/7/2014)
Ok, good, I'm not the only one who would think 'blocking' long before thinking 'let me post this impossible situation on the forums'
Oh blocking, yeah that must have...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 7, 2014 at 3:19 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 6, 2014 at 2:10 pm
Viewing 15 posts - 991 through 1,005 (of 3,666 total)