×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
This original question is turning out to be a doozy.
Nice try Rob, but what happens if qtemp/foxwell contains
2, 3,5 and 999,999,999 what do you do?
Alan Shore
NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill
rob@xxxxxxxxx
Sent by:
midrange-l-bounce To
s@xxxxxxxxxxxx Midrange Systems Technical
Discussion
<midrange-l@xxxxxxxxxxxx>
04/16/2008 08:55 cc
AM
Subject
Re:
Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
This works on V6R1
with list(counter) as
(values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10))
select counter from list
where counter not in(select thekey from qtemp/foxwell)
So if qtemp/foxwell contains 2, 3 and 5 you will get back: 1, 4, 6, 7, 8,
9, 10
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
midrange.com
