Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Month Wise Display

Author  Topic 

maran_mail
Starting Member

5 Posts

Posted - 2008-04-16 : 03:16:50
Hi,

Start Date: (mm/dd/yyyy) 05/09/2007
End Date: (mm/dd/yyyy) 08/20/2007

While giving the start date and end date using the above values, need to display the report like the following format.

Notes: Need Single query

Start Date End Date
05/09/2007 05/31/2007
06/01/2007 06/30/2007
07/01/2007 07/31/2007
08/01/2007 08/20/2007

Please do the needful help as soon as possible time.

Thank you.

Manimaran.Ramaraj
Software Engineer
Aspire Systems
Chennai - 600 028
   

- Advertisement -