Dates To Spans (SQL Time Gaps)

Recently I had a table such as this: ID  BEGIN_DATE 2600      01-JAN-08 2600      01-FEB-08 2600      01-MAR-08 2600      01-JUL-13 3318      01-APR-08 3318      01-JUL-13 … … which signifies when a particular ID is active on a monthly basis.  When it isn’t, it just does not show up.  I thought it would be more concise and useful for […]

Read more