Viewing 15 posts - 2,191 through 2,205 (of 4,080 total)
😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 18, 2009 at 10:21 am
Hey Trudye:
You need to think about this a little. Your [CEFDT] is NOT really a date. It is a numeric column holding a bunch of numbers...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2009 at 9:31 pm
America learned, Jeff.
Lynn we are all grateful to your daughter and all those like her for their service and sacrifice. God bless her and keep...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2009 at 9:10 pm
Trying to use case statements to return different datatypes will fail in some cases (like mixing character data with numeric. ) Why you would want to is beyond me...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2009 at 9:25 am
You're almost there...
SELECT z.ZipCode, z.CountyName,
MAX(CASE WHEN productid = 1 THEN customerid end) AS 'product1',
MAX(CASE WHEN productid = 2 THEN customerid end)...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2009 at 9:09 am
No need to cast everything as float. This will work too.
select 1.0*1/100
-- but not
select 1/100*1.00
SQL resolves each step of a calculation and returns the result using the more...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2009 at 8:58 am
I don't know, Jeff. After seeing the kindler/gentler you in action in that "urgent" thread that the OP never came back to, I'd say it's time 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
October 17, 2009 at 8:45 am
Ohhhh..... you mean real physical objects... not higher level code constructs. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2009 at 1:56 pm
I got the term from early William Gibson: Neuromancer / Count Zero, but Gus got it right with his link.
Did anyone here ever play a card game called...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2009 at 1:02 pm
The volcanic super-eruption of Yellowstone should shatter and melt a lot of the glacial ice, although the ash from the blast will probably bring on global cooling as well as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2009 at 12:58 pm
Black Ice
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2009 at 12:26 pm
Jeff,
I have a couple of questions:
(1) Who are you, and (2) what have you done with Jeff Moden?
Alternatively:
(1) What kind of tranquilizers are you taking?
(2) Do...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2009 at 10:35 am
I was going to do a version with a CTE, but it wouldn't have been substantively different from your solution, Ken.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2009 at 8:47 am
Hey Elliot... what kind of cookies?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2009 at 8:09 am
Jordon, where is the last number stored, if not in the table you are inserting to? I see an immediate conflict if you are inserting a set of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2009 at 8:04 am
Viewing 15 posts - 2,191 through 2,205 (of 4,080 total)