In the column i have the value 6696...for example. I select it in a select statement and divide by 100...this brings back 66.
I want to convert it to decimal (or whatever is the most appropiate) and return the proper value which is 66.96.
I have been using the below hacked together statement (which works) but it keeps putting trailing zeros after the 2 digits to the right of the decimal place. I want the figure to only 2 decimal places as thats all there ever will be. Is there a neater way to do this.
SELECT Convert(Decimal(10,2),(SUM(NormalHours)))/100 as 'TotalNormalHours' FROM Wages