Getting Previous month Particular dates in Sql

Thanks,
R.Vasanth
MCTS(SQL Server & BI)
http://bigdatatech.blogspot.com

Regards,
Ravi

Declare @month int



Declare @year int



set @month = 10

set @year = 2012





Declare @temp table(

	[date] datetime

)



Declare @day int



Select @day = DATEPART(D,GETDATE())



Declare @present_startdate datetime



set @present_startdate=CONVERT(datetime,cast(@day as varchar)+'/'+cast(@month as varchar)

	+'/'+cast(@year as varchar),103)



declare @i int



set @i = 0



Declare @previous_month_startdate datetime



set @previous_month_startdate = dateadd(M,-1,@present_startdate)

 

while datediff(D,@previous_month_startdate,@present_startdate) <> 0

begin

	

	set @previous_month_startdate =DATEADD(D,1,@previous_month_startdate )



	Insert into @temp values(@previous_month_startdate )

	

	set @i= @i+1

end



select CONVERT(varchar,[date],103) from @temp

Sourabh07