DonlSimpson (10/28/2014)
select left(cast(sum(saletotal) as money) / NumberofDays, CHARINDEX('.', cast(cast(sum(saletotal) as money) / NumberofDays as varchar(max)), 1) + 2)
A lot of work to round a value to 2 decimal points. Try this:
select round(sum(saletotal) * 1.0 / NumberOfDays, 2);