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 429,996 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,432 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: Programming Forums

Thread Tools Display Modes

Views: 8109 | Replies: 10 | Solved

Page 2 of 2

•

Join Date: Dec 2004

Location: London or Slovakia

Posts: 2,476

Reputation: peter_budo is a jewel in the rough

Rep Power: 11

Solved Threads: 298

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.