sql comparison and flag
From: bigbinc <bigbinc_at_hotmail.com>
Date: 25 Oct 2003 07:48:58 -0700
Message-ID: <d1b33313.0310250648.26f69385_at_posting.google.com>
Date: 25 Oct 2003 07:48:58 -0700
Message-ID: <d1b33313.0310250648.26f69385_at_posting.google.com>
I need to compare two tables and print the differences(vbscript). Is
there a quick sql way to do this. Otherwise I have a O(n^2) problem.
What I am doing now is getting the data from the 2nd table first and
then printing the 1st table and checking if the value matches the 2nd
table. O(n^2)
lets say I have ids
Get Table 2 data
3 4 5
Print Table 1 and Flag:
Is there a better way?
Received on Sat Oct 25 2003 - 16:48:58 CEST
1 - no O(n)
2 - no O(n)
3 - yes O(n)
4 - yes O(n)
5 - yes O(n)
6 - no O(n)