Thanks for your suggestion Eugene

Compare1 Compare2

1-1-1 1-1-1

1-1-2 1-1-2

I got these rows when I...

Jason,

I am getting the data when i run the query that you sent..

I have added condition in where statement like this:

where Compare1=Compare2

But it gives an error that:

Msg 207, Level...