M
MikeR
I've got a table (tmplog) that I need to retrieve sorted by
freq(number), mode, cid. (Select * from tmplog ordered by freq, mode
CID). The problem is that I need to treat a range of numbers as a
single number, for instance between 1 an 2 as though they were all the
same number and between 3 and 4 as the same, etc. I'm not sure at this
point how the CIDs will come out, as they are of different lengths(1-5).
There are 12 ranges in all, but maybe this will convey the idea. I've
included a set returned incorrectly, and below that, how it needs to be.
Thanks, Mike
Here is the result of my query.
CALL Freq Mode CID
AA4MM 1.8 PHO K
V47KP 1.8 PHO V4
VE3EJ 1.8 PHO VE
VP9DX 1.8096 PHO VP9
VP5VW 1.83 CW VP5
CY9CWI 1.83 PHO CY9
ZL7C 1.8305 CW ZL7
TI4CF 1.833 CW TI
XE1RCS 1.833 PHO XE
P49I 1.8336 CW P4
WP2DX 1.8338 PHO KP2
C6AJT 1.834 PHO C6
C6AHX 1.836 CW C6
NP4A 1.85007 PHO KP4
C6APU 3.5 CW C6
DL2NBU 3.5 CW DL
VE3KTN 3.5 CW VE
FP8CO 3.5 PHO FP
W1NG 3.5 PHO K
ND0U 3.5 PHO K
KK9A 3.5 PHO K
VE3EJ 3.5 PHO VE
CY0AA 3.513 CW CY0
VP2EZA 3.5194 CW VP2E
VP5VW 3.5393 CW VP5
W4GKM 3.5852 TTY K
K9MUG 3.58604 TTY K
N2WK 3.59244 TTY K
XE1YYD 3.5935 TTY XE
TO5M 3.7 PHO FP
PJ9B 3.7 PHO PJ2
Here's how I need it.
CALL Freq Mode CID
C6AHX 1.836 CW C6
P49I 1.8336 CW P4
TI4CF 1.833 CW TI
VP5VW 1.83 CW VP5
ZL7C 1.8305 CW ZL7
C6AJT 1.834 PHO C6
CY9CWI 1.83 PHO CY9
AA4MM 1.8 PHO K
WP2DX 1.8338 PHO KP2
NP4A 1.85007 PHO KP4
V47KP 1.8 PHO V4
VE3EJ 1.8 PHO VE
VP9DX 1.8096 PHO VP9
XE1RCS 1.833 PHO XE
C6APU 3.5 CW C6
CY0AA 3.513 CW CY0
DL2NBU 3.5 CW DL
VE3KTN 3.5 CW VE
VP2EZA 3.5194 CW VP2E
VP5VW 3.5393 CW VP5
FP8CO 3.5 PHO FP
TO5M 3.7 PHO FP
W1NG 3.5 PHO K
ND0U 3.5 PHO K
KK9A 3.5 PHO K
PJ9B 3.7 PHO PJ2
VE3EJ 3.5 PHO VE
W4GKM 3.5852 TTY K
K9MUG 3.58604 TTY K
N2WK 3.59244 TTY K
XE1YYD 3.5935 TTY XE
freq(number), mode, cid. (Select * from tmplog ordered by freq, mode
CID). The problem is that I need to treat a range of numbers as a
single number, for instance between 1 an 2 as though they were all the
same number and between 3 and 4 as the same, etc. I'm not sure at this
point how the CIDs will come out, as they are of different lengths(1-5).
There are 12 ranges in all, but maybe this will convey the idea. I've
included a set returned incorrectly, and below that, how it needs to be.
Thanks, Mike
Here is the result of my query.
CALL Freq Mode CID
AA4MM 1.8 PHO K
V47KP 1.8 PHO V4
VE3EJ 1.8 PHO VE
VP9DX 1.8096 PHO VP9
VP5VW 1.83 CW VP5
CY9CWI 1.83 PHO CY9
ZL7C 1.8305 CW ZL7
TI4CF 1.833 CW TI
XE1RCS 1.833 PHO XE
P49I 1.8336 CW P4
WP2DX 1.8338 PHO KP2
C6AJT 1.834 PHO C6
C6AHX 1.836 CW C6
NP4A 1.85007 PHO KP4
C6APU 3.5 CW C6
DL2NBU 3.5 CW DL
VE3KTN 3.5 CW VE
FP8CO 3.5 PHO FP
W1NG 3.5 PHO K
ND0U 3.5 PHO K
KK9A 3.5 PHO K
VE3EJ 3.5 PHO VE
CY0AA 3.513 CW CY0
VP2EZA 3.5194 CW VP2E
VP5VW 3.5393 CW VP5
W4GKM 3.5852 TTY K
K9MUG 3.58604 TTY K
N2WK 3.59244 TTY K
XE1YYD 3.5935 TTY XE
TO5M 3.7 PHO FP
PJ9B 3.7 PHO PJ2
Here's how I need it.
CALL Freq Mode CID
C6AHX 1.836 CW C6
P49I 1.8336 CW P4
TI4CF 1.833 CW TI
VP5VW 1.83 CW VP5
ZL7C 1.8305 CW ZL7
C6AJT 1.834 PHO C6
CY9CWI 1.83 PHO CY9
AA4MM 1.8 PHO K
WP2DX 1.8338 PHO KP2
NP4A 1.85007 PHO KP4
V47KP 1.8 PHO V4
VE3EJ 1.8 PHO VE
VP9DX 1.8096 PHO VP9
XE1RCS 1.833 PHO XE
C6APU 3.5 CW C6
CY0AA 3.513 CW CY0
DL2NBU 3.5 CW DL
VE3KTN 3.5 CW VE
VP2EZA 3.5194 CW VP2E
VP5VW 3.5393 CW VP5
FP8CO 3.5 PHO FP
TO5M 3.7 PHO FP
W1NG 3.5 PHO K
ND0U 3.5 PHO K
KK9A 3.5 PHO K
PJ9B 3.7 PHO PJ2
VE3EJ 3.5 PHO VE
W4GKM 3.5852 TTY K
K9MUG 3.58604 TTY K
N2WK 3.59244 TTY K
XE1YYD 3.5935 TTY XE