SQL Server 2005-Sequentail Dates

Sunday, May 4, 2014

Note : I am using SQL Server 2005.


I have table called ProjectStage which has the following structure:


ProjectID StageID StartDate EndDate P1 02 01/02/2014 24/02/2014 P1 02 25/02/2014 20/05/2014 P1 02 30/05/2014 31/12/2015 P2 25 20/03/2014 25/042014


So i want a query to get the result as:


ProjectID StageID StartDate EndDate P1 02 01/02/2014 20/05/2014 P1 02 30/05/2014 31/12/2015 P2 25 20/03/2014 25/04/2014


Your help is highly appreciated.


Regards.







http://ift.tt/1oidSQU