Hi,

I have 2 tables.
I have to compare whether the data in those 2 tables are same or not.
( For example : I have to find, how many records different between
those 2 tables, if those tables are almost similar)

How can i find this ?


With Regards,
Raja

On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Hi, Raja

Does (your version of) Sybase support the DIFFERENCE operation (maybe
called MINUS or EXCEPT)? If not, you could do something as ungainly as
export the data to files and compare them using, e.g., diff or CSDiff,
assuming the row count's not prohibitive.

--Jeff

On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Hi, Raja

Does (your version of) Sybase support the DIFFERENCE operation (maybe
called MINUS or EXCEPT)? If not, you could do something as ungainly as
export the data to files and compare them using, e.g., diff or CSDiff,
assuming the row count's not prohibitive.

--Jeff

On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Hi, Raja

Does (your version of) Sybase support the DIFFERENCE operation (maybe
called MINUS or EXCEPT)? If not, you could do something as ungainly as
export the data to files and compare them using, e.g., diff or CSDiff,
assuming the row count's not prohibitive.

--Jeff

On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Hi, Raja

Does (your version of) Sybase support the DIFFERENCE operation (maybe
called MINUS or EXCEPT)? If not, you could do something as ungainly as
export the data to files and compare them using, e.g., diff or CSDiff,
assuming the row count's not prohibitive.

--Jeff

On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Hi, Raja

Does (your version of) Sybase support the DIFFERENCE operation (maybe
called MINUS or EXCEPT)? If not, you could do something as ungainly as
export the data to files and compare them using, e.g., diff or CSDiff,
assuming the row count's not prohibitive.

--Jeff

On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Hi, Raja

Does (your version of) Sybase support the DIFFERENCE operation (maybe
called MINUS or EXCEPT)? If not, you could do something as ungainly as
export the data to files and compare them using, e.g., diff or CSDiff,
assuming the row count's not prohibitive.

--Jeff

On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Hi, Raja

Does (your version of) Sybase support the DIFFERENCE operation (maybe
called MINUS or EXCEPT)? If not, you could do something as ungainly as
export the data to files and compare them using, e.g., diff or CSDiff,
assuming the row count's not prohibitive.

--Jeff

On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Hi, Raja

Does (your version of) Sybase support the DIFFERENCE operation (maybe
called MINUS or EXCEPT)? If not, you could do something as ungainly as
export the data to files and compare them using, e.g., diff or CSDiff,
assuming the row count's not prohibitive.

--Jeff

On Oct 6, 3:41*pm, jefftyzzer <jefftyz... (AT) sbcglobal (DOT) net> wrote:
Raja:

Just to help expedite your efforts lest I keep you in suspense,
assuming that Sybase does have DIFFERENCE/MINUS/EXCEPT functionality,
the general pattern for comparing table contents using that method is:

SELECT
COUNT (*)
FROM
(
(
SELECT
*
FROM
table1
MINUS
SELECT
*
FROM
table2
)
UNION
(
SELECT
*
FROM
table2
MINUS
SELECT
*
FROM
table1
)
) X;

--Jeff