Jeff Moden (11/15/2010)
Still, it would be nice to hear back from those folks that gave the lower ratings . . .
I didn't give a low rating, but found a slip of the pen (it confused me for a moment).
-- This builds a table with random dates and amounts for 20 years
-- starting in the year 2000.
SELECT TOP (1000000)
SomeDateTime = RAND(CHECKSUM(NEWID()))*7305 + CAST('2005' AS DATETIME),
The 2000 from the comment is not the same as the CAST('2005' AS DATETIME)