adonetok (5/16/2013)
In fact, in real table there are about 20 colums and 200 ID need to check cell by cell.I do not think that without loop can do it.
Can someone help me?
Does the solution given by Sean earlier work for your 3 columns as required?
If Yes, whats the problem in implementing it for 20 columns?
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/