it helps some times Isn't that the registered trademark symbol? I believe you hit on one of sql server 2005's defences against odbc based attacks. Since there isn't anything on the internet about it, it is likely something MS handled internally.
help you fix your problem Check the table definition. If it's a Number, it can be an Integer (Byte, Integer, Long Integer) type or a Real (Single, Double, etc.) The integers will always round. Also, if you are using a real type, the Decimal option may have an effect as well
Get data between each 5 year in SQL Server (like 1990-1995, 1995-2000, 2000-2005)
With these it helps I have a table orders with columns orderid and OrderDate. , I think this is a clear syntax, using one subquery:
SELECT CAST(T.YearDivision * 5 AS nchar(4)) + N' - ' + CAST(T.YearDivision * 5 + 4 AS nchar(4)) AS YearRange, SUM(T.TotalCount) AS TotalOrders
SELECT YEAR(Date) / 5 AS YearDivision, Date, COUNT(*) AS TotalCount
GROUP BY Date
GROUP BY YearDivision