sql date operation split


can greatfully let me know sql separate date ranges overlap?



data (sample information date operation presumably columns):



    col1 fromdate todate
1. 1 1/1/2008 31/12/2010
2. 1 1/1/2009 31/12/2012
3. 1 1/1/2009 31/12/2014


output:



   col1  date todate
1. 1 1/1/2008 31/12/2008 (from quarrel 1 above)
2. 1 1/1/2009 31/12/2010 (from rows 1,2 3 above)
3. 1 1/1/2011 31/12/2012 (from rows 2 3 above)
4. 1 1/1/2013 31/12/2014 (from quarrel 3 above)


Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members