<div>
<div class="content wysiwyg-content">
I'm having trouble combining rows with dates across more than one rows with no breaks 
in time: 
 
Example: 
 
TableA 
 
&nbsp; &nbsp; &nbsp; Key &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eff_dt &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; term_dt 
 
&nbsp; &nbsp; &nbsp;1234 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/01/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/01/2012 
&nbsp; &nbsp; &nbsp; 1234 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/02/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/31/9999 
 
 
Result set should be: 
 
&nbsp; &nbsp; &nbsp; 1234 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02/01/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/31/9999 
 
 
If this situation: 
 
&nbsp; &nbsp; &nbsp; &nbsp;5678 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/01/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/01/2012 
&nbsp; &nbsp; &nbsp; &nbsp;5678 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/03/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/31/9999 
 
Since there is a one day not covered both rows &nbsp;(03/02/2012 not included) would be in the result set.
</div>
</div>

I'm having trouble combining rows with dates across more than one rows with no breaks
in time:

Example:

TableA

      Key                              eff_dt                       term_dt

     1234                             02/01/2012                 03/01/2012
      1234                            03/02/2012                 12/31/9999


Result set should be:

      1234                            02/01/2012                  12/31/9999


If this situation:

       5678                           02/01/2012                   03/01/2012
       5678                           03/03/2012                   12/31/9999

Since there is a one day not covered both rows  (03/02/2012 not included) would be in the result set.

combining rows with dates across multiple rows  - A SQL question

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.