Viewing 15 posts - 5,506 through 5,520 (of 9,715 total)
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
If the domains don't trust each other, I don't think any amount of SQL perms verification will help. Check with your domain admin to make sure that A) the domains...
July 25, 2011 at 10:40 am
You have to turn the whole statement into a dynamic SQL statement. You can't just assign variables to the various bits of it. Do you know how to do dynamic...
July 25, 2011 at 10:38 am
Have you compared execution plans between the regular SELECT and the SELECT...INTO queries?
July 25, 2011 at 10:34 am
mtillman-921105 (7/25/2011)
July 25, 2011 at 10:32 am
halifaxdal (7/25/2011)
Brandie Tarvin (7/25/2011)
halifaxdal (7/25/2011)
SSMS is not reliable and it's very buggy
What sort of problems are you having with it? If you post detailed problem descriptions / error messages, we...
July 25, 2011 at 10:30 am
halifaxdal (7/25/2011)
SSMS is not reliable and it's very buggy
What sort of problems are you having with it? If you post detailed problem descriptions / error messages, we might be able...
July 25, 2011 at 9:31 am
Revenant (7/25/2011)
Brandie Tarvin (7/25/2011)
crookj (7/25/2011)
Ray K (7/25/2011)
Daniel Bowlin (7/25/2011)
ruthlesspeople
Despicable
Me
Really?
Movie title. "Despicable Me."
July 25, 2011 at 8:56 am
Viewing 15 posts - 5,506 through 5,520 (of 9,715 total)