TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Lynn Emery
NA
47
56.3k
Numbers after decimal place not showing.
Feb 18 2013 6:06 AM
Hi,
I have a problem with displaying numbers after a decimal place in my SQL statement.
For example if I was to calculate 125/511 * 1000 my sql statement would present the answer as 244.00 rather than 244.62.
My sql statement is as follows:
CAST(SUM(Refunds) / SUM(sales) * 1000 AS DECIMAL(9, 2))
Please note that 'Refund' and 'Sale' data also have a decimal (9,2) data format, as I initially thought that data type inconsistency may have been causing the issue.
I welcome your suggestions and thank you for your help.
Reply
Answers (
3
)
SQL 12 Month graph
Load million of record from file to sql db table within min.