Splitting a date range into multiple date ranges according to input given

Hi All



We need to split date range into the multiples date ranges according to the input provided.



For example suppose we have a two different date ranges in a table, like,



01 Jan 2014 - 31 Dec 2014

01 Jan 2015 - 31 Mar 2015



and we got input for new date range as,



01 Jan 2014 - 28 Feb 2014

01 Aug 2014 - 31 Aug 2014

01 Feb 2015 - 28 Feb 2015



then output in new table should get values like,



01 Jan 2014 - 28 Feb 2014

31 Mar 2014 - 21 Jul 2014

01 Aug 2014 - 31 Aug 2014

01 Sep 2014 - 31 Dec 2014

01 Jan 2015 - 31 Jan 2015

01 Feb 2015 - 28 Feb 2015

01 Mar 2015 - 31 Mar 2015





Can any one help for the solution for same with the best performance?

Thanks in advance

Regards