22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @SQL VARCHAR(8000)
DECLARE @TABLEJOIN VARCHAR(8000)
SET @SQL='SELECT T1.name,T1.value'
SET @TABLEJOIN=' FROM #T T1'
SELECT @SQL=@SQL+',T'+CAST(RN AS VARCHAR(10))+'.name,T'+CAST(RN AS VARCHAR(10))+'.value'
,@TABLEJOIN=@TABLEJOIN+' LEFT JOIN #T T'+CAST(RN AS VARCHAR(10))+' ON T'+CAST(RN AS VARCHAR(10))+'.RN='+CAST(RN AS VARCHAR(10))
FROM #T WHERE RN>1
SET @SQL=@SQL+@TABLEJOIN+' WHERE T1.RN=1'
PRINT @SQL
EXEC(@SQL)