Money and Decimal Datatypes

Question

Post reply

Money and Decimal Datatypes

Kaminda

SSC Journeyman

Points: 77
More actions
April 16, 2011 at 3:50 pm

#235795

Comments posted to this topic are about the item Money and Decimal Datatypes

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Good question - makes one recall the baics...

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

M&M SSC-Insane Points: 21700 More actions · Answer 2

M&M

SSC-Insane

Points: 21700

April 17, 2011 at 12:59 am

#1312494

Nice question, thanks.

M&M

Abi Chapagai SSCrazy Points: 2666 More actions · Answer 3

Abi Chapagai

SSCrazy

Points: 2666

April 17, 2011 at 1:00 pm

#1312535

Good question.

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 4

Great question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

ziangij SSCrazy Eights Points: 8066 More actions · Answer 5

ziangij

SSCrazy Eights

Points: 8066

April 17, 2011 at 11:58 pm

#1312598

good question, thanks.:-)

srikant maurya Hall of Fame Points: 3293 More actions · Answer 6

srikant maurya

Hall of Fame

Points: 3293

April 18, 2011 at 12:00 am

#1312600

Good Question

Thanks

Carlo Romagnano SSC-Insane Points: 22772 More actions · Answer 7

It's a good habit always to specify precision and scale because of changing default in future releases.

Toreador SSChampion Points: 11382 More actions · Answer 8

Of course strictly speaking the result will be 90.3400 as the result will be of type money

cengland0 SSCertifiable Points: 6102 More actions · Answer 9

cengland0

SSCertifiable

Points: 6102

April 18, 2011 at 3:02 am

#1312641

Easy point today. Love straight-forward questions.

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 10

Duncan Pryde

SSCertifiable

Points: 7956

April 18, 2011 at 3:36 am

#1312646

Thanks for a good question.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 11

Daniel Bowlin

SSC-Dedicated

Points: 34566

April 18, 2011 at 6:48 am

#1312716

DOH! I clicked too fast. Good question.

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 12

I knew the decimal would have zero places past the decimal but I thought it would round the ANSWER, not just that part of the expression, since it was an expression with 2 different datatypes. I need to do more expressions with mixed datatypes.

Great question!

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

pdooley-1104895 Newbie Points: 4 More actions · Answer 13

I wish you would have asked about a SET @dvalue = 10.12

Even though I got the answer correct the 10.10 clouds weather the (10) or the (.10) is the number being stored.

good question! Peace

SQLRNNR SSC Guru Points: 281344 More actions · Answer 14

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Money and Decimal Datatypes

Cookies on SQLServerCentral