Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How would I go about splitting multiple date bands into individual dates?

So from something like this:

DateStart
2013-01-01
2013-01-06

DateEnd
2013-01-03
2013-01-08 

To something like this...

2013-01-01
2013-01-02
2013-01-03
2013-01-06
2013-01-07
2013-01-08

Thank you in advance,

Andy

share|improve this question
3  
Please do not cross-post: stackoverflow.com/questions/18845043/… –  ypercube Sep 17 '13 at 8:57
    
Also, how do you make date pairs into 'bands'? Are they always in ascending order? –  dezso Sep 17 '13 at 15:01
    
@pix1985 did not the question on stackoverflow solve your issue ? The Idea is to use calendar table. –  Kin Sep 18 '13 at 0:00
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.