Comparing two rows in a Table

#1

Hi Gurus,

Is there any automated way to compare the contents of TWO rows in the same
table of SQL Server ?

Thanks in advance.

Regards,
Yog

#2

Compare them?

In what way?

In DTS ?

DTS has no task to do this explicitly but you can do this in TSQL almost
certainly depending on what "Compare them means" exactly.

If you let us know more I'm sure we can help.

Allan

"Yog" <Yog (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi Gurus,

Is there any automated way to compare the contents of TWO rows in the same
table of SQL Server ?

Thanks in advance.

Regards,
Yog

#3

To precisely put it , the content of the problem is as below

Objective :- Compare TWO rows contents for few selected Columns. If they are
different then show those columns with the contents.
ENV:- SQL Server 2000 , T-SQL, SQL Server Tools (No other programming
language or front end)

"Allan Mitchell" wrote:

Quote:

Compare them?

In what way?

In DTS ?

DTS has no task to do this explicitly but you can do this in TSQL almost
certainly depending on what "Compare them means" exactly.

If you let us know more I'm sure we can help.

Allan

"Yog" <Yog (AT) discussions (DOT) microsoft.com> wrote in message
news:Yog (AT) discussions (DOT) microsoft.com:

Hi Gurus,

Is there any automated way to compare the contents of TWO rows in the same
table of SQL Server ?

Thanks in advance.

Regards,
Yog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Comparing two rows in a Table

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Comparing two rows in a Table - 03-17-2005 , 12:17 PM

Re: Comparing two rows in a Table - 03-17-2005 , 12:48 PM

Re: Comparing two rows in a Table - 03-18-2005 , 01:41 AM