Viewing 15 posts - 1,246 through 1,260 (of 9,725 total)
MMartin1 (1/10/2017)
Brandie Tarvin (1/10/2017)
MMartin1 (1/10/2017)
drew.allen (1/10/2017)
MMartin1 (1/9/2017)
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT...
January 10, 2017 at 12:24 pm
MMartin1 (1/10/2017)
drew.allen (1/10/2017)
MMartin1 (1/9/2017)
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL...
January 10, 2017 at 12:09 pm
BrainDonor (1/10/2017)
jasona.work (1/10/2017)
My normal 30 minute drive to work took an hour, the roads were crap and slick, and I've got a little rear-wheel drive sporty car.
Winter tyres. My wife...
January 10, 2017 at 12:05 pm
Wow. I haven't talked to any of you guys since last year. Happy New Year, I hope everyone is doing well.
Quick question(s). Does anyone here hold a CISSP cert?
The SO...
January 10, 2017 at 6:54 am
djj (1/10/2017)
January 10, 2017 at 6:52 am
rodjkidd (1/9/2017)
Sorry for the late notice but I only booked today!
I'm near Oxford Circus tomorrow for a camera flash course. It finishes at 4 30. So could meet...
January 10, 2017 at 6:51 am
Michael L John (12/18/2016)
I left one thing out. I neglected to tell any of the other departments, like support,the names of the new servers.
That's not leaving something out. That's...
January 10, 2017 at 6:45 am
TomThomson (12/17/2016)
Brandie Tarvin (12/12/2016)
January 10, 2017 at 6:44 am
Rasmus Remmer Bielidt (1/5/2017)
this will yield NULL due...
January 5, 2017 at 5:08 am
Rasmus Remmer Bielidt (1/5/2017)
Brandie Tarvin (1/5/2017)
Rasmus Remmer Bielidt (1/5/2017)
I didn't see anybody making this point, but COALESCE() absolutely needs a non-null argument or it...
January 5, 2017 at 4:49 am
Rasmus Remmer Bielidt (1/5/2017)
I didn't see anybody making this point, but COALESCE() absolutely needs a non-null argument or it will throw an error where...
January 5, 2017 at 4:37 am
drew.allen (1/4/2017)
CASE is clearly more flexible than COALESCE, because it can perform any conditional test whereas COALESCE only tests whether an expression is NULL, and because it can return any...
January 5, 2017 at 4:36 am
Alan.B (1/4/2017)
Sorry for the off-topic rant; just some food for thought.
Not at all off topic. You made some very good points. As did Luis about using the functions.
Thank you both...
January 5, 2017 at 4:29 am
Eric M Russell (1/4/2017)
If the user entered codes are not relationally tied to any other table, then what are the ramifications of them being entered "wrong" ?
As I said, these...
January 4, 2017 at 12:50 pm
Just to clarify. The data is coming from a vendor-created database. I cannot make changes to it. I can, however, send emails to the users saying "Fix this item, it...
January 4, 2017 at 11:26 am
Viewing 15 posts - 1,246 through 1,260 (of 9,725 total)