Pivot - result in new table - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Pivot - result in new table

Author

Topic

Clas
Starting Member

33 Posts

Posted - 2009-09-22 : 08:13:19

Hi.

How can I insert result to a new table like:

SELECT xx.*
INTO test
FROM xx

Result from:

DECLARE @cols VARCHAR(8000)
SELECT @cols = COALESCE(@cols + ',[' + Column_Name_txt + ']',
'[' + Column_Name_txt + ']')
FROM Data_Column_Name
ORDER BY Column_Name
--print @cols
DECLARE @query VARCHAR(8000)
SET @query = N'SELECT FatherID, '+
@cols +'
FROM
(SELECT t2.FatherID
, t1.Column_Name_txt
, t2.Column_Value
FROM Data_Column_Name AS t1
JOIN Data_pivot AS t2 ON t1.Column_Name_txt = t2.Column_Name_txt) p
PIVOT
(
MAX([Column_Value])
FOR Column_Name_txt IN
( '+
@cols +' )
) AS pvt
ORDER BY FatherID;'

EXECUTE(@query)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-09-25 : 13:52:13

just use

INSERT
EXEC...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources