Viewing 15 posts - 5,506 through 5,520 (of 9,722 total)
john.arnott (7/25/2011)
Gus,Thanks for the encouragement. I've submitted my meta-QOD.
And I can't wait to complain about the correct answer to it! @=)
July 25, 2011 at 12:34 pm
Ninja's_RGR'us (7/25/2011)
Please not 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 this reply...
July 25, 2011 at 12:28 pm
Ninja's_RGR'us (7/25/2011)
Brandie Tarvin (7/25/2011)
July 25, 2011 at 12:23 pm
GilaMonster (7/25/2011)
SQLRNNR (7/25/2011)
GilaMonster (7/25/2011)
mtillman-921105 (7/25/2011)
July 25, 2011 at 12:12 pm
rbond 51820 (7/25/2011)
July 25, 2011 at 12:04 pm
Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to me, Gus, and...
July 25, 2011 at 12:02 pm
Dynamic SQL is when you populate a variable with a SQL query or another stored procedure. Read up on sp_executesql when you get a chance, so you understand what can...
July 25, 2011 at 11:53 am
Welsh Corgi (7/25/2011)
Yes, also grab some pencils. 🙂
😛
@=)
July 25, 2011 at 11:39 am
I have to agree with Gus & Ninja. Yes, you can do it, but there are so many things that can go wrong with that method (like accidentally deleting the...
July 25, 2011 at 11:20 am
Why are you converting your dates to strings?
I have always had problems with BETWEEN dropping records on me, so I never use it. I always go this route:
SH_ACCT.open_dt >= dateadd(mm,datediff(mm,0,dateadd(mm,-2,getdate())),0)...
July 25, 2011 at 11:14 am
Yes, because SANS are set up in different ways and also have different hardware. Some SANS have 1 disk controller, others have multiples. Also, it depends on how the LUNS...
July 25, 2011 at 11:10 am
I think your scenario highlights a very real problem with Full-Text.
The searches are based on words, and variations of words, that SQL "knows." Because you are using proper names,...
July 25, 2011 at 11:05 am
You could always use the RIGHT and LEFT functions.
Declare @MyVar char(6);
Set @MyVar = 'abcdef';
Select @MyVar = LEFT(RIGHT(@MyVar,5),4);
Select @MyVar;
UPDATE import_table
SET cost_code=@MyVar;
July 25, 2011 at 10:59 am
I agree with everything everyone said so far. I would just like to add that it may be easier for you to draw things out before you start physically designing...
July 25, 2011 at 10:54 am
DBA in Unit 7 (7/25/2011)
July 25, 2011 at 10:42 am
Viewing 15 posts - 5,506 through 5,520 (of 9,722 total)