Yeah he's good, spends all day bitchin'...

Having spent a little time on this, I reckon the following code snippet should help. You will need to use appropriate string conversions and NULL checking so that the columns...

SELECT * FROM #TAB1 EXCEPT SELECT * FROM #TAB2

SELECT * FROM #TAB2 EXCEPT SELECT * FROM #TAB1

A deadlock occurs when
tran 1 has a lock on object A and cannot continue without also obtaining a lock on object B
and
tran2 has a lock...

Thanks.

-- remove "noise" - anything which isn't required as output, or for the query to function

-- use proper...

You can't have different numbers of columns in different rows.
Can you post the whole query?

It's called a Crosstab or Pivot query. An excellent article by ssc's Jeff Moden shows how to do it:

http://www.sqlservercentral.com/articles/T-SQL/63681/

Holler if you need a hand....