Viewing 15 posts - 4,486 through 4,500 (of 18,926 total)
ramineni.suresh661 (7/26/2011)
With above reply it Giving following Error Message
Column '#TempA.LOGIN_ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY...
July 26, 2011 at 6:15 am
GilaMonster (7/26/2011)
Once more with feeling anybody?http://www.sqlservercentral.com/Forums/Topic1148024-1291-1.aspx
Maybe it's time to add your mvp title back to your sig! 😉
July 26, 2011 at 6:04 am
Gianluca Sartori (7/26/2011)
Grant Fritchey (7/26/2011)
July 26, 2011 at 6:03 am
Chazz88 (7/26/2011)
July 26, 2011 at 5:54 am
Convert the column to an int and the order will work... and be faster than the switch.
July 26, 2011 at 5:50 am
Kiara (7/26/2011)
Ninja's_RGR'us (7/26/2011)
... Hence they compound the fact by proving they don't know something by commenting over and over about it :w00t:.
Thanks for the tip!
:w00t: And now, to clean up...
July 26, 2011 at 5:48 am
Kiara (7/26/2011)
Ninja's_RGR'us (7/26/2011)
That's impossible Bit! People love to complain and that's just a great way to complain about your own biaised opinion :exclamation:
People don't like to feel stupid, so...
July 26, 2011 at 5:39 am
I'd go the other way around. Script all objects and recreate the db from scratch. Then maybe import the lookup tables (Types, states, countries, etc).
You cannot use truncate...
July 26, 2011 at 5:14 am
bitbucket-25253 (7/25/2011)
Tom.Thomson (7/25/2011)
Ninja's_RGR'us (7/25/2011)
It's a little weird ±5 days after the fact and I still don't see the new wording as...
July 26, 2011 at 5:06 am
Tom.Thomson (7/25/2011)
The responses intrigued me - I saw the question after Steve's correction, not before, so had to go an look at the daily email to see what the original...
July 25, 2011 at 5:52 pm
Brandie Tarvin (7/25/2011)
Ninja's_RGR'us (7/25/2011)
Please note he said COPY and not MOVE. If something bad happens during the move you lose the DB, copy is safer there.
Ninja, I'm sorry, but...
July 25, 2011 at 4:16 pm
Please not he said COPY and not MOVE. If something bad happens during the move you lose the DB, copy is safer there.
July 25, 2011 at 12:18 pm
Brandie Tarvin (7/25/2011)
July 25, 2011 at 12:10 pm
Nothing??
What does this return?
CREATE TABLE #logs (LogDate DATETIME, ProcessInfo VARCHAR(50), Txt VARCHAR(MAX))
INSERT INTO #logs (LogDate, ProcessInfo, Txt)
EXEC master.sys.xp_readerrorlog 0,1
INSERT INTO #logs (LogDate, ProcessInfo, Txt)
EXEC master.sys.xp_readerrorlog 1,1
INSERT INTO #logs (LogDate, ProcessInfo,...
July 25, 2011 at 11:59 am
Steve Jones - SSC Editor (7/25/2011)
I have corrected the typo and rewritten the question a bit. I've awarded back points as well
Is that some sort of special deal where we...
July 25, 2011 at 11:58 am
Viewing 15 posts - 4,486 through 4,500 (of 18,926 total)