I am using MS-SQL 2005
I have a query that returns inventory items and quantities but the numbers that are returned have five zeros at the end of each number
so 45 is returned as 45.00000
How can I get it to return just the 45?
Here is my query