select
distinct PrDt,
ROW_NUMBER() Over(Order by PrDT) as RowNumber
from MyTable
group by PrDt
--RESULT
PrDt RowNumber
---------------------- --------------------
03-02-2009 1
03-04-2009 2
03-05-2009 3
(3 row(s) affected)