Viewing 15 posts - 2,566 through 2,580 (of 4,080 total)
Okay Barry, reading about your hospital stay reminds me that I truly have no problems and should quit my bitching. I will say a little prayer for your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 9:24 am
*POUND*
*POUND*
*POUND*
Ow, my head.... where the @#$%# is that spare keyboard!!! :crazy:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 8:55 am
I didn't lose any sleep over it, but please remember it for the future. There are lots of new and improved techniques between 2005 and 2000. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 6:44 am
O Lynn, merciful patron Saint of Patience, tell us where we have failed.
Have we not asked the OP for data?
Have we not shown the OP the link to Jeff's article...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 6:36 am
Hi again Trudye. What we have here is failure to communicate. The abbreviated schema you sent earlier were fine. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 6:24 am
You gotta love it. He passes out a solution that performs faster AND (to me) reads simpler. But no, they still want him to rewrite...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 11:52 pm
But Jeff ... What if they'd said "Pretty please, with sugar on top" ?? 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 11:29 pm
For what it's worth, I saw no difference in the execution plan for your example whether or not a SET or a SELECT is used. Apparently...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 10:19 pm
Listen to the little green master. Wise he is in the ways of the Forum...
I love your new avatar too, Lynn. It radiates awesomeness.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 10:08 pm
Got it. I was looking at the difference in execution plans, and you example has a compute scalar... which obviously calculates a single value. 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
August 20, 2009 at 10:06 pm
Hey Jeffery, thanks for joining in. 🙂
I will confess to totally overlooking the null set as you illustrated. So let me ask you this question:
Why does...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 8:19 pm
Schema are good to have as a start. Now how about some values in those fields, like this?
declare @A table (id int, name varchar(5))
insert into @A
select 1,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 8:04 pm
NULL is the absence of a value in a column for a given row (or a variable), not the absence of a row.
@@ROWCOUNT is the count of rows returned or...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 7:45 pm
Hey Trudye 🙂
Could you please supply us with a little sample data to work with? It really isn't clear from the code you've posted, and would be...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 7:32 pm
Duplicate post. Reply here.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 20, 2009 at 4:21 pm
Viewing 15 posts - 2,566 through 2,580 (of 4,080 total)