FORMAT that string

Question

FORMAT that string

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
February 28, 2018 at 8:08 pm

#100969

Comments posted to this topic are about the item FORMAT that string

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

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

Ken SSCoach Points: 17191 More actions · Answer 1

Hmmm, can you double check that answer Steve? Nice presentation on SQL In the City by the way. Hope your cough went away!

HappyGeek SSCoach Points: 18726 More actions · Answer 2

HappyGeek

SSCoach

Points: 18726

February 28, 2018 at 10:33 pm

#1981580

Similarly confused!?

...

Carlo Romagnano SSC-Insane Points: 22597 More actions · Answer 3

What's the result of the following query?

SELECT FORMAT(COUNT(*),'#') FROM HolydaysToDo WHERE HolydaysToDo.Name = 'Steve Jones'
The result:
Arithmetic overflow error converting expression to data type bigint

A lot of days

😀😀

Eirikur Eiriksson SSC Guru Points: 182881 More actions · Answer 4

Although I never use the format function because of it's horrific performance, I am pretty certain that the alleged answer is not the correct one.
😎

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 5

Joining the throng of questions on the answer here!!! I'm pretty sure it is currently wrong!

edwardwill SSCertifiable Points: 5789 More actions · Answer 6

edwardwill

SSCertifiable

Points: 5789

March 1, 2018 at 2:13 am

#1981595

Yet another wrong QoTD.

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 7

Gah, not sure what I was thinking. Must have gotten distracted as I was moving the code over. Corrected. The answer and explanation should be 0####

Stewart "Arturius" Campbell SSC Guru Points: 72496 More actions · Answer 8

Glad i answered after the correction was applied.
Nice question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

GaryV Hall of Fame Points: 3307 More actions · Answer 9

I too answered after it was corrected and got it right.

But ... storing zip codes in a numeric field? Bah. Just because something is made up of numerals (like a zip code, phone number, ssn) doesn't mean it's numeric. Store the data correctly and you won't need to format it.

Jedak SSCertifiable Points: 5520 More actions · Answer 10

The correct answer should be E. None of the above. Store postal codes as string values.

Luis Cazares SSC Guru Points: 183698 More actions · Answer 11

Jedak - Thursday, March 1, 2018 7:52 AM
The correct answer should be E. None of the above. Store postal codes as string values.

And don't use FORMAT

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

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

Jedak - Thursday, March 1, 2018 7:52 AM
The correct answer should be E. None of the above. Store postal codes as string values.

Amen to that. They often contain a four digit group separated by a dash.

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 13

Steve Jones - SSC Editor

SSC Guru

Points: 734418

March 1, 2018 at 9:53 am

#1981659

Should != reality. Unfortunately.

Toreador SSChampion Points: 11358 More actions · Answer 14

Revenant - Thursday, March 1, 2018 9:06 AM
Jedak - Thursday, March 1, 2018 7:52 AM
The correct answer should be E. None of the above. Store postal codes as string values.
Amen to that. They often contain a four digit group separated by a dash.

and outside the USA they could contain anything...