|
|
Posted by Ed Murphy on 10/07/06 23:02
Rsapru@gmail.com wrote:
> Thanks for replying.. it a lil bit.. but if we add some more data
> ... query goes bonkers... thanks anyways
Can you give a specific example of a data set for which the query
misbehaves?
Also, here is your initial example:
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
and a visual layout of which uid's fall within which time slots:
1 1
2 1
3 27
4 27
5 378
6 378
7 348
8 348
9 48
10
11 5
12 56
13 6
and finally your initial example of the desired output:
effdate termdate uid
1 2 1
11 13 2
3 9 3
The ranges (1-2, 3-9, 11-13) make sense, but why do you have 11-13
associated with uid 2, and 3-9 with 3? I would expect 11-13 to be
associated with one of uid's (5,6), and 3-9 with one of (2,3,4,7,8).
Navigation:
[Reply to this message]
|