Wednesday, 18 September 2013

tsql: How to retrieve the last date of each month between two dates

tsql: How to retrieve the last date of each month between two dates

I have two date for example 08/08/2013 and 11/11/2013 and I need last date
of each month starting from August to November in a table so that i can
iterate over the table to pick those dates individually.
I know how to pick last date for any month but i am stucked with a date
range.
kindly help, it will be highly appreciated.
Note : I am using Sql 2008.

No comments:

Post a Comment