Viewing 15 posts - 7,636 through 7,650 (of 9,401 total)
To keep the query running, you don't have to do anything except let it run. The next guy (who will need the password to the machine to be able...
August 5, 2014 at 10:58 am
Hello and welcome to the forums!
If all you're after is to get the most recent date from ep.ReviewDate, this should suffice:
SELECT MAX(ep.ReviewDate)
FROM table_name ep;
If you want to get...
August 5, 2014 at 10:26 am
Allow me to cast my vote for Luis's second approach. I use the same approach myself when i need to de-dupe data. It divides the work into two...
August 5, 2014 at 10:19 am
What SSMS is saying is that you have a query running and closing SSMS will abort it. If you have a query that takes a long time to run,...
August 5, 2014 at 10:17 am
Jeff Moden (8/5/2014)
Eirikur Eiriksson (8/4/2014)
Jeff Moden (8/4/2014)
Eirikur Eiriksson (8/4/2014)
Koen Verbeeck (8/4/2014)
Lynn Pettis (8/4/2014)
Whom ever has the Great Mystical Crystal Ball, you are needed here.
I am afraid I have left it...
August 5, 2014 at 9:55 am
The single most important piece of advice I can give you is to test it on a test system before doing it in production.
The first reason is a trust issue....
August 5, 2014 at 6:31 am
I did something almost identical several years ago (over FTP, not SFTP) using batch files to do an mget and then delete them. The problem I saw was that...
August 5, 2014 at 6:24 am
Cute. I think they left out a couple of things. My favorite is responding to the statement from users "The internet is down" in the middle of the...
August 5, 2014 at 6:10 am
Thanks for the question. Honestly, I used inline assignment so much that I didn't even give it a second look. The += however, I had to look three...
August 5, 2014 at 5:51 am
Eirikur Eiriksson (8/4/2014)
Koen Verbeeck (8/4/2014)
Lynn Pettis (8/4/2014)
Whom ever has the Great Mystical Crystal Ball, you are needed here.I am afraid I have left it in my other coat...
I'm relying on...
August 4, 2014 at 2:06 pm
I don't see a question, but it is definitely a stack trace from .NET. Looks to me like a login doesn't have permission to do something against INFORMATION_SCHEMA.Columns. ...
August 4, 2014 at 2:04 pm
SQLRNNR (8/4/2014)
djj (8/4/2014)
"Here's the rule: if my 14-yr old smart daughter could find the answer on Google from your question, you'd shouldn't ask...
August 4, 2014 at 11:21 am
ALZDBA (8/4/2014)
Koen Verbeeck (8/4/2014)
ALZDBA (8/4/2014)
Koen Verbeeck (8/4/2014)
I have a rather large DWH query. For testing purposes I singled out one single ID.
But sometimes the query returned 1 row,...
August 4, 2014 at 8:22 am
GilaMonster (8/4/2014)
And vague question of the week award goes to: http://www.sqlservercentral.com/Forums/Topic1599205-391-1.aspxI want to make my search query faster and accurate.
DO i need to use any algorithem in SQL?
So early in...
August 4, 2014 at 5:45 am
Viewing 15 posts - 7,636 through 7,650 (of 9,401 total)