MSSql动态行转列

SET NOCOUNT ON;
CREATE TABLE #Month([Month] INT primary Key,MonthAmount INT);
DECLARE @Count INT=12,@i INT = 0,@Sql NVARCHAR(4000)=N'';
WHILE @i<@Count BEGIN
	SET @i=@i+1;
	INSERT INTO #Month VALUES(@i,CONVERT(INT,RAND()*10000));
	END

SELECT @Sql=CONCAT(@Sql
	,SPACE(4),IIF(@Sql='','',','),'[Month',[Month],']=',MonthAmount,CHAR(10)
	)
FROM #Month;
SET @Sql = CONCAT('SELECT ',CHAR(10),@Sql);
EXEC SP_EXECUTESQL @Sql;
PRINT @Sql;
DROP TABLE #Month;
SET NOCOUNT OFF;

 

转载于:https://www.cnblogs.com/microtry/p/6209222.html