您的资料
DECLARE @TABLE TABLE (sip_RECno INT,user1 VARCHAr(10),user2 VARCHAr(10),user3 VARCHAr(10),user4 VARCHAr(10))INSERT INTO @TABLE VALUES(1,'ram','ravi','sam','raj')
询问
;WITH CTEAS ( SELECt * FROM ( SELECt user1 ,user2 ,user3 , user4 FROM @TABLE) T UNPIVOT ( Value FOR N IN (user1 ,user2 ,user3 , user4))P ) SELECt Value AS Users FROM CTE
结果集
鈺斺晲鈺愨晲鈺愨晲鈺愨晲鈺�鈺� Users 鈺�鈺犫晲鈺愨晲鈺愨晲鈺愨晲鈺�鈺� ram 鈺�鈺� ravi 鈺�鈺� sam 鈺�鈺� raj 鈺�鈺氣晲鈺愨晲鈺愨晲鈺愨晲鈺�
