FORMAT that string

Question

FORMAT that string

Steve Jones - SSC Editor

SSC Guru

Points: 736255
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: 18729 More actions · Answer 2

HappyGeek

SSCoach

Points: 18729

February 28, 2018 at 10:33 pm

#1981580

Similarly confused!?

...

Carlo Romagnano SSC-Insane Points: 22670 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: 182912 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: 5851 More actions · Answer 6

edwardwill

SSCertifiable

Points: 5851

March 1, 2018 at 2:13 am

#1981595

Yet another wrong QoTD.

Steve Jones - SSC Editor SSC Guru Points: 736255 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: 72626 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: 5579 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: 183706 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: 736255 More actions · Answer 13

Steve Jones - SSC Editor

SSC Guru

Points: 736255

March 1, 2018 at 9:53 am

#1981659

Should != reality. Unfortunately.

Toreador SSChampion Points: 11365 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...