Thanx i got it . And the sol is : declare @current varchar(100) set @current =(select convert(varchar,getdate(),101)) declare @firstdate varchar(100) declare @lastdate varchar(100) set @firstdate=(SELECT convert( varchar,DATEADD(dd,-(DAY(DATEADD(mm,1,@current))-1),DATEADD(mm,0,@current)),101)) set @lastdate=(SELECT convert(varchar, DATEADD(dd, -DAY(DATEADD(m,1,@current)), DATEADD(m,1,@current)),101)) print @firstdate print @lastdate declare @i int declare @k varchar(100) select @i = datediff(dd,@firstdate,@lastdate) print @i declare @j int set @j=0 while(@j<@i) begin select @k = dateadd( dd,1,@firstdate) print @k set @firstdate=@k set @j =@j + 1 end