SQL Rounding Problems in 2005 and 2000

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

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
FROM
(
    SELECT YEAR(Date) / 5 AS YearDivision, Date, COUNT(*) AS TotalCount
    FROM Orders
    GROUP BY Date
) T
GROUP BY YearDivision

YearRange   TotalOrders
----------- -----------
2005 - 2009 2680
2010 - 2014 1395

should help you out For SQL Server 2008 and above, you can do use DATETIME2. DATETIME2 is available in SQL Server 2008 and above - for more info see here:

SELECT CAST('1900-01-01 00:10:10.830' AS DATETIME2(0));
SELECT CAST('1900-01-01 00:10:10.430' AS DATETIME2(0));

SELECT DATEADD(ms, -DATEPART(ms, DATEADD(ms, 500, CAST('1900-01-01 00:10:10.830' AS DATETIME))) , DATEADD(ms, 500, CAST('1900-01-01 00:10:10.830' AS DATETIME)));
SELECT DATEADD(ms, -DATEPART(ms, DATEADD(ms, 500, CAST('1900-01-01 00:10:10.430' AS DATETIME))) , DATEADD(ms, 500, CAST('1900-01-01 00:10:10.430' AS DATETIME)));