Viewing 15 posts - 706 through 720 (of 3,666 total)
Why should 10 be selected? Its status is paid, but that status has not changed.
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]
June 9, 2015 at 2:44 pm
ericpap (6/9/2015)
Alvin Ramard (6/9/2015)
ericpap (6/9/2015)
Alvin Ramard (6/9/2015)
Have you discussed this problem...
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]
June 9, 2015 at 12:30 pm
ericpap (6/9/2015)
Alvin Ramard (6/9/2015)
Have you discussed this problem with the server...
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]
June 9, 2015 at 12:19 pm
Jack Corbett (6/9/2015)
ArnolddG (6/9/2015)
That works okay.
One more thing. My query is about 140 lines long.
Is there a way to do the If Then on...
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]
June 9, 2015 at 12:13 pm
I can't help but wonder if someone is trying to "reset the clock" to prevent the RTM version from expiring.
Have you discussed this problem with the server administrator?
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]
June 9, 2015 at 12:12 pm
ArnolddG (6/9/2015)
I have standard SQL query for clients, but sometimes a client does not have a specific table.
How do I deal with that? (creating the table is not an option)
SELECT
...
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]
June 9, 2015 at 8:43 am
Lynn Pettis (6/8/2015)
...Please note, I'd rather leave the formatting of the output to the front end instead of doing here in the query.
+ 1
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]
June 8, 2015 at 2:20 pm
Have you looked at the event logs for the server?
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]
June 8, 2015 at 2:19 pm
Steve Jones - SSC Editor (6/8/2015)
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]
June 8, 2015 at 2:16 pm
I have an idea. You could use a case statement to set the sales amount to 0.00 if the year and month for the revenue is not the same...
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]
June 8, 2015 at 2:02 pm
If you want a record for each revenue for each month of each year, then I do not see how you can do that without repeating the sale in each...
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]
June 8, 2015 at 1:46 pm
If I were doing this, where I already had SSIS packages running, I wouldn't waste my time looking for other possibilities. I'd do it in SSIS.
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]
June 8, 2015 at 11:46 am
jpserra3 (6/8/2015)
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]
June 8, 2015 at 10:18 am
There can be more than one correct answer here, including just restoring the last log backup.
Are we correct in assuming that you want the correct sequence that starts with restoring...
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]
June 8, 2015 at 8:06 am
spaghettidba (6/8/2015)
This is what you need:
1. Last full backup
2. Last differential
3. All the log backups taken after...
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]
June 8, 2015 at 7:35 am
Viewing 15 posts - 706 through 720 (of 3,666 total)