Viewing 15 posts - 5,521 through 5,535 (of 9,726 total)
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
zapouk (7/22/2011)
July 25, 2011 at 8:51 am
I love chapter 2, The First Programmer was a Lady.
July 25, 2011 at 8:44 am
crookj (7/25/2011)
Ray K (7/25/2011)
Daniel Bowlin (7/25/2011)
ruthlesspeople
Despicable
Me
July 25, 2011 at 8:32 am
Let me see if I understand your situation correctly.
You want to update A, B & C when none of these columns equal the A, B, and C columns from another...
July 22, 2011 at 10:42 am
Viewing 15 posts - 5,521 through 5,535 (of 9,726 total)