Not sure what you want to do

if you have these dates in a table then its

SELECT TOP 10 mydatefield FROM mytable

if you dont then

       Dim dateArr(9)
       For i = 0 To -9 Step -1
           dateArr(Math.Abs(i)) = DateAdd(DateInterval.Day, i,
DateAndTime.Now)
           Response.Write(DateAdd(DateInterval.Day, i, DateAndTime.Now))
           Response.Write("<br>")
       Next

There are loads of ways you could do this.

The following isn't particular robust or efficient, but it should be enough
to get you started:

CREATE TABLE #tmpDates
(
   dtmDate smalldatetime
)
DECLARE @i tinyint
SET @i = 0
WHILE @i < 11
BEGIN
   INSERT #tmpDates VALUES(DATEADD(day, @i * -1, getdate()))
   SET @i = @i + 1
END
SELECT * FROM #tmpDates ORDER BY dtmDate DESC
DROP TABLE #tmpDates

simple query:

  with foo (d , level)
  as
  (
    select getdate(),1
    union all
    select dateadd(day,-level,d), level + 1
    from foo
    where level < 10
  )
  select d
  from foo

-- bruce (sqlwork.com)