-
Date Split - Sql help
hi Sql Gurus,
This is challenging sql for me , i hope you could solve this.
I have a table with following info
SDate EDate Value
10/10/2002 10/15/2002 15
10/12/2002 10/14/2002 28
10/20/2002 10/30/2002 30
Sql should return like this
SDate EDate Value
10/10/2002 10/11/2002 15
10/12/2002 10/14/2002 28
10/15/2002 10/15/2002 15
10/20/2002 10/30/2002 30
The SQL is to split the records if the date range is overlapped. If it's fully overlapped sql should return one record for the overlapping.
Any help/suggestion is appreciated.
[Cursor/dynamic sql also okay for me]
Thanks
Senthil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|