 | |
#11
 
| |||
| |||
|
Re: Comparison of 2 Tables -
10-06-2008
, 06:50 PM
|
On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote: 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 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 |
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
#12
| |||
| |||
|
|
On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote: 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 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 |
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
#13
| |||
| |||
|
|
On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote: 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 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 |
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
#14
| |||
| |||
|
|
On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote: 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 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 |
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
#15
| |||
| |||
|
|
On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote: 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 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 |
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
#16
| |||
| |||
|
|
On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote: 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 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 |
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
#17
| |||
| |||
|
|
On Oct 3, 9:56*am, raja <dextersu... (AT) gmail (DOT) com> wrote: 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 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 |
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
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.