Posted by Rsapru on 10/04/06 03:09

i have a table containing following data
effdate termdate uid
----------- ----------- -----------
1 2 1
3 4 2
5 8 3
7 9 4
11 12 5
12 13 6
3 6 7
5 9 8

i need to replace all the overlapping records with one record
such that resultant table shud look like


effdate termdate uid
1 2 1
11 13 2
3 9 3


Thanks

• Next in forum: Calrification on number of columns fetched to server memory
• Prev in forum: Re: Best way to force a varchar column to have no whitespace
• Thread view: Date overlapping

[Reply to this message]