Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Report Writer: Rounding Status

I'm running a report on a custom value from UnDP status field using Advance SQL. How can I round the "status" number field to the nearest 10th?

Thanks!

Find more posts tagged with

Accepted answers

would this reference be any help for you? http://technet.microsoft.com/en-us/library/ms175003.aspx

All comments

would this reference be any help for you? http://technet.microsoft.com/en-us/library/ms175003.aspx

Thanks for the suggestion! It turns out the variable I was trying to round was listed in the DB as a varchar instead of a float or int. However, thank you so much for the response as that link is helpful.

Quick Links