Viewing 15 posts - 3,181 through 3,195 (of 4,080 total)
:blink:
__________________________________________________
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 3, 2009 at 4:05 pm
(groan) :pinch:
__________________________________________________
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 3, 2009 at 3:56 pm
Congratulations Grant!!
and Gary....
Okay, have moved from the Son Of Thread to this one. Seems more appropriate somehow.
...... Congratulations on turning away from the Dark Side.
__________________________________________________
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 3, 2009 at 12:33 pm
Both "Ping Pong Ball" and "Elephant" have three vowels.
Both "Ping Pong Ball" and "Cricket" contain the letter "I".
__________________________________________________
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 3, 2009 at 10:37 am
You're welcome, gnethery, and thanks for taking the time to tell us it works for you.
__________________________________________________
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 3, 2009 at 10:29 am
I checked it out. Thanks Gus.
The article describes the way I've always done it, but it's still using dynamic SQL. I will have to remember that...
__________________________________________________
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 3, 2009 at 9:51 am
Same problem. Sorry about that. I was originally excited about PIVOT until I realized that it wasn't truly dynamic like pivot tables in Excel....
__________________________________________________
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 3, 2009 at 9:40 am
Gus is right. You want to do something dynamically without using dynamic SQL.
If I read what you want correctly, you want to produce something like this
WHERE @var...
__________________________________________________
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 3, 2009 at 9:21 am
You're very welcome. I will pass the credit for time and effort to the bright people who made the optimizer smart enough to produce elegant executions plans from...
__________________________________________________
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 3, 2009 at 7:32 am
You're welcome, Luis.
CROSS APPLY is a very useful technique to "join" both subqueries and Inline Table Valued Functions. The optimizer generates very efficient execution plans when I've used this...
__________________________________________________
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 3, 2009 at 7:30 am
Lynn is correct. Two points for the little green Master. :hehe:
__________________________________________________
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 2, 2009 at 8:52 pm
I'm sure you'll work it out, mate. 😛
__________________________________________________
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 2, 2009 at 8:37 pm
Here is an example of finding the last of anything in 2005. Runs quick.
declare @tbl table (dept varchar(10), name varchar(10), rowID int identity(1,1))
insert into @tbl
select 'Shipping','Amy' union all
select...
__________________________________________________
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 2, 2009 at 8:29 pm
There might be a lot of page splits happening as the table is rebuilt.
It's not like you are adding a varchar field with no data in it....
__________________________________________________
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 2, 2009 at 8:11 pm
So three guys check into a fancy hotel together wanting to share a single room. The night clerk tells them the room is $300 for the night. ...
__________________________________________________
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 2, 2009 at 8:00 pm
Viewing 15 posts - 3,181 through 3,195 (of 4,080 total)