Thanks for your response....
Yes I have run a loop like below
declare @i int=900000
declare @mydate date=getdate()
set @mydate= dateadd(day,-1,@mydate)
However it is not working as the last date it shows like 01-01-01....What I have done is that I have given first 10,000 a single date and then next 10,000 another date and so on....
However your input has helped me to solve it.