smrobin (9/13/2013)
Thanks for the reply - the problem I have is that I don't always know what the number will be. I have the rules to which I apply to the numbers.
Not sure who you are talking to!
Since you did not provide any dll or sample data, it had to be made up. Both solutions are generic in that you have to modify either of them to use your table and your column names. Also, both solutions are rounding up whatever is passed to them. There is no "fixed" value.
I was hoping to write a simple case statement to handle everything.
Is that not what I posted?
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/