Getting rid of NULL

Question

Post reply

Getting rid of NULL

Steve Jones - SSC Editor

SSC Guru

Points: 736150
More actions
January 7, 2017 at 11:24 am

#75757

Comments posted to this topic are about the item Getting rid of NULL
January 16, 2017 at 12:04 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 1

Mr. Kapsicum

SSCertifiable

Points: 6128

January 9, 2017 at 12:06 am

#1921300

Nice and Easy.

Thanks

paul s-306273 SSChampion Points: 10730 More actions · Answer 2

paul s-306273

SSChampion

Points: 10730

January 9, 2017 at 2:06 am

#1921317

Thanks for QOTD Steve.

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 3

It was so easy, I had to re-read the question & answers a few times looking for the "trick".

(:

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

Thanks for the question. Hope this doesn't count as spam.

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Kaye Cahs (1/9/2017)
It was so easy, I had to re-read the question & answers a few times looking for the "trick".
(:

+1

Thanks, Steve!

Ken SSCoach Points: 17191 More actions · Answer 6

Nice and easy way to start the week. Thanks Steve.

MMartin1 One Orange Chip Points: 27795 More actions · Answer 7

Yes, not difficult that I re-read a couple times to make sure I was not missing anything. Though the wording could be better "I want to return the nickname if there is one, then the firstname,..." made me believe initially that there was more than one column to be returned.

----------------------------------------------------

DamianC SSCrazy Eights Points: 8023 More actions · Answer 8

DamianC

SSCrazy Eights

Points: 8023

January 10, 2017 at 1:46 am

#1921555

Thanks for the question

- Damian

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 9

Mr. Kapsicum

SSCertifiable

Points: 6128

January 10, 2017 at 2:08 am

#1921559

Thanks for the question.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

I also read it several times looking for the trick. Turned out to be an easy one.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

g.maxfield Default port Points: 1471 More actions · Answer 11

I got the answer correct but it say's I got it wrong?

SELECT 'name' = COALESCE( nickname, firstname, firstname2) FROM dbo.Contacts
SELECT 'name' = COALESCE( nickname, firstname, firstname2) FROM dbo.Contacts

IanSinclair SSCertifiable Points: 6111 More actions · Answer 12

MMartin1 - Monday, January 9, 2017 3:55 PM
Yes, not difficult that I re-read a couple times to make sure I was not missing anything. Though the wording could be better "I want to return the nickname if there is one, then the firstname,..." made me believe initially that there was more than one column to be returned.

g.maxfield Default port Points: 1471 More actions · Answer 13

Thanks - I rushed it so I missed the trap! Thanks G