--===== Declare some obviously named variables
DECLARE @NumberOfRows INT,
        @StartValue   INT,
        @EndValue     INT,
        @Range        INT
;
--===== Preset the variables to known values
 SELECT @NumberOfRows = 1000000,
        @StartValue   = 400,
        @EndValue     = 500,
        @Range        = @EndValue - @StartValue + 1
;
--===== Conditionally drop the test table to make reruns easier in SSMS
     IF OBJECT_ID('tempdb..#SomeTestTable','U') IS NOT NULL
        DROP TABLE #SomeTestTable
;
--===== Create the test table with "random constrained" integers and floats
     -- within the parameters identified in the variables above.
 SELECT TOP (@NumberOfRows)
        SomeRandomInteger =  ABS(CHECKSUM(NEWID())) % @Range + @StartValue,
        SomeRandomFloat   = RAND(CHECKSUM(NEWID())) * @Range + @StartValue
   INTO #SomeTestTable
   FROM sys.all_columns ac1
  CROSS JOIN sys.all_columns ac2

SELECT MinFloat=MIN(SomeRandomFloat), MaxFloat=MAX(SomeRandomFloat)
FROM #SomeTestTable

DROP TABLE #SomeTestTable

MinFloat           MaxFloat
400.000012322329   500.999933381006

--===== Declare some obviously named variables
DECLARE @NumberOfRows INT,
        @StartValue   INT,
        @EndValue     INT,
        @Range        INT,
        @FStartValue  INT,
        @FEndValue    INT,
        @FRange       INT
;
--===== Preset the variables to known values
 SELECT @NumberOfRows = 1000000,
        @StartValue   = 400,
        @EndValue     = 500,
        @Range        = @EndValue - @StartValue + 1,
        @FStartValue  = 400,
        @FEndValue    = 500,
        @FRange       = @EndValue - @StartValue
;
--===== Conditionally drop the test table to make reruns easier in SSMS
     IF OBJECT_ID('tempdb..#SomeTestTable','U') IS NOT NULL
        DROP TABLE #SomeTestTable
;
--===== Create the test table with "random constrained" integers and floats
     -- within the parameters identified in the variables above.
 SELECT TOP (@NumberOfRows)
        SomeRandomInteger =  ABS(CHECKSUM(NEWID())) % @Range  + @StartValue,
        SomeRandomFloat   = RAND(CHECKSUM(NEWID())) * @FRange + @FStartValue,
        SomeRandomDate    = RAND(CHECKSUM(NEWID())) * @Range  + 
            DATEADD(day, -@StartValue, DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0))
   INTO #SomeTestTable
   FROM sys.all_columns ac1
  CROSS JOIN sys.all_columns ac2

SELECT MinFloat=MIN(SomeRandomFloat), MaxFloat=MAX(SomeRandomFloat)
    ,MinDate=MIN(SomeRandomDate), MaxDate=MAX(SomeRandomDate)
FROM #SomeTestTable

DROP TABLE #SomeTestTable

MinFloat           MaxFloat                    MinDate                    MaxDate
400.000069523232   499.999990152787            2011-05-04 00:00:16.187    2011-08-12 23:59:58.753