I get the same thing without the "()". In SQL 2005 BOL, the "()" are noted as the new correct syntax. It still works without for backward compatibility.

I reported this to MS as a bug.  Here's something that should work to return the correct number of rows using NTILE:

--------------------------

CREATE TABLE #tmp

(intValue int)

DECLARE @value int

SET @value...