 |
 |
Archives of the TeradataForum
Message Posted: Tue, 05 Sep 2006 @ 12:14:22 GMT
| Subj: | | Re: How to merge contiguous date ranges |
| |
| From: | | Victor Sokovin |
| | First correct answer wins a poke in the eye with a blunt stick. | |
Looks like you've been already rewarded with a similar prize as your example does not seem to match the description.
This should be easy to do with recursive SQL (available on V6). I think I can recall a few similar examples posted recently. As the prize does
not look tempting I think I should just refer you to the archives.
If you are not on V6, try a third-party tool. For example, Oracle.
Regards,
Victor
| |
