Viewing 15 posts - 3,091 through 3,105 (of 4,080 total)
See if these are quick enough for you. The use of FOR XML is the fastest concatenation technique I've come across, but this sort of string manipulation is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 6:24 pm
For what it's worth, JOIN is the standard we use too, for both readability and reliability.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 5:59 pm
Hopefully some of the rest of us will be on hand to listen.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 3:20 pm
What a maroon... what a gulli-bull...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 3:18 pm
I would follow Magoo's approach of making this table-driven for the sake of flexibility.
Might be a good idea to add an index to his ReportKeys table.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 2:10 pm
Hey... who are you callin' an oxymoron!? :unsure:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 2:03 pm
Hi Flo:
No I don't create them, I use Google Image Search, and there are also websites that post collections of images. "Biohazard" seems to inspire a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 12:15 pm
I must confess, I don't approve of your schema either.
However, this will give you the result you're looking for.
declare @test-2 table (PK1 int, pk2 int, TitleOrder int, Title varchar(20),...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 12:09 pm
By the way, Gail. I asked for authority instead of experience because you can usually quote chapter and verse from BOL. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 11:42 am
I just tested it and answered my own question. The Join on ShortCode+'%' did NOT interfere with the proper use of the index. It produced...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 11:40 am
I was thinking about the LIKE solution earlier, but that would make the join be
INNER JOIN T2 ON LongCode like ShortCode+'%'
Doesn't the ShortCode+'%' expression create the same problem as the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 11:27 am
Gail, do you have some authority for us on the joins using the LEFT function?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 10:23 am
You should feel safer now, too. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 10:07 am
:w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 8:39 am
I don't believe I've ever used a GOTO in T-SQL, if I ever knew they existed. But today I learned that they "are not uncommon" in T-SQL. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 11, 2009 at 8:34 am
Viewing 15 posts - 3,091 through 3,105 (of 4,080 total)