Viewing 15 posts - 1,246 through 1,260 (of 9,720 total)
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
Eric M Russell (1/4/2017)
January 4, 2017 at 11:21 am
Luis Cazares (1/4/2017)
IF (SELECT OBJECT_ID('tempdb..#MyTemp')) IS NOT NULL
DROP TABLE #MyTemp;
CREATE TABLE #MyTemp (QuestionableColumn CHAR(20));
INSERT INTO #MyTemp (QuestionableColumn)
VALUES ('ABC1GKUCEEF7AR169582'), --Good value
('ABC2G1WG5E37D1157775'), --Good value
('BCD3GTU2TEC9FG119962'), --Good...
January 4, 2017 at 11:20 am
Thom A (1/4/2017)
Brandie Tarvin (1/4/2017)
Thom A (1/4/2017)
January 4, 2017 at 11:17 am
drew.allen (1/4/2017)
Brandie Tarvin (1/4/2017)
I like CASE personally because it allows me to alter values being returned (or add new information) where as COALESCE just returns the original value.
But you can...
January 4, 2017 at 10:50 am
The main differences between CASE and COALESCE() are that COALESCE() is faster to type and CASE gives you other data manipulation options. Otherwise, they are mostly identical in the way...
January 4, 2017 at 8:51 am
Viewing 15 posts - 1,246 through 1,260 (of 9,720 total)