How to get the result for smaller number divide larger number?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,590 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,668 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 7598 | Replies: 10 | Solved

Page 2 of 2

•

Join Date: Dec 2004

Location: London or Slovakia

Posts: 2,134

Reputation: peter_budo has a spectacular aura about

Rep Power: 10

Solved Threads: 257

peter_budo peter_budo is offline

Offline

Code tags enforcer

Re: How to get the result for smaller number divide larger number?

#11

Jun 17th, 2008

•

Originally Posted by sujendra

the integer division is done. so the result is in integer.
try select convert(numeric(5,2), 50)/100 OR
select 50.00/100.00

Another genius...

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.