to do with the list, You could try something like
update yourTable set selected=0
where primKey in
(select primKey from yourTable where primKey in
(#List1#) MINUS
select primKey from yourTable where primKey in
(#List2#)
)
Clever combinations of the basic set operations using
UNION, MINUS, and NOT IN will perform set operations
on lists.
--- "Robertson-Ravo, Neil (RX)"
<[EMAIL PROTECTED]> wrote:
> Anyone know if and how you can compare two lists in
> SQL?
>
> real world examples could be
>
> List 1 : 1,54,36,98,32,67
> List 2 : 54,98,67
>
> Which obviously means 1,36,32 have been removed
>
> and indeed this could also be possible :
>
> List 1 : 1,54,36,98,32,67
> List 2 : 54,98,67,36,100,12
>
> Which obvioulsy means that 1 & 32 have been removed
> and 100 & 12 have been
> added....
>
> its a puzzler...it must be able to be be
> done.......?
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
