Viewing 15 posts - 1,351 through 1,365 (of 4,080 total)
Understood. Thanks for taking the time.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 24, 2010 at 5:53 am
I thought it was Bob and Ray.
Moving along now, Lynn.
Apologies to all for dragging this into the Thread. I should have let it go.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 9:59 pm
This was a perfectly reasonable question, but of the answers to date only Leo's was reasonable: the others were disgraceful.
I resemble that remark, but having been involved for an...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 8:30 pm
Hey Paul, I revisited this and noticed that your last post replaced the cross apply of a VALUES clause with a subquery containing a lot of SELECT/UNION all statements. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 3:55 pm
You use the word "win" in an odd context, Gail.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 12:33 pm
Want to bet on crime statistics?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 11:42 am
You gamble every day you LIVE in Memphis.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 11:39 am
I agree with Howard. Do you require assistance in slowing it down?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 11:38 am
Steve Jones - Editor (9/23/2010)
Jason, be nice. You're hurting Bob's feelings.
'
Yeah, and my feelings are soooooo tender. :crying:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 11:36 am
If I wanted to gamble on slots, Tunica is close enough.
I don't gamble a lot either, Jason, and my preferred game is actually poker for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 11:34 am
CirquedeSQLeil (9/23/2010)
The Dixie Flatline (9/23/2010)
CirquedeSQLeil (9/23/2010)
The Dixie Flatline (9/23/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 10:20 am
select *
from #t1
where item in (select item from #t1 group by item having COUNT(distinct value) > 1)
Talk about your low hanging fruit...
Mine could be just a bit longer.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 10:00 am
CirquedeSQLeil (9/23/2010)
The Dixie Flatline (9/23/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 8:58 am
Part of the problem is just knowing the terminology. Newbies have to phrase their objective without buzzwords or technical terms of art.
building a comma separated string (concatenate)
converting...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 8:55 am
I didn't bother, and I'm not going to.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 8:38 am
Viewing 15 posts - 1,351 through 1,365 (of 4,080 total)