SQL Statement Memo: non-int type row to column

For example, the result is a varchar type, need row to column, Baidu to is the operation of the type int, toss a long time, just the whole out, here to prepare a forget, but it is said that the performance is worrying, so here also see the big God pointing guidance, where can improve, thank you.

1 --does not apply to fields that have type text, ntext, etc. that cannot perform distinct operations2 SELECT DISTINCTA.code,3(SELECTResult fromTest bWHEREA.code=B.code andB.type=1) as'First Instance',4(SELECTResult fromTest bWHEREA.code=B.code andB.type=2) as'Review'5  fromTest A

1 SelectA.code,a.result'First Instance', B.result'Review'  from 2(SELECTCode,result fromTestWHEREType=1) A3  Inner Join(SELECTCode,result fromTestWHEREType=2) b onA.code=B.code

SQL Statement Memo: non-int type row to column