How to get row column values as row headers in sql server

DECLARE @PivotColumnHeaders VARCHAR(MAX),@SQLquery AS NVARCHAR(MAX);

SELECT @PivotColumnHeaders = COALESCE(@PivotColumnHeaders + ',[' + cast(A.FieldName as varchar) + ']','[' + cast(A.FieldName as varchar)+ ']')
FROM dbo.tablename A -- where ID =5

print @PivotColumnHeaders


set @SQLquery = 'SELECT date, ' +@PivotColumnHeaders + ' from 
            (
                select date
                    , amount
                    , FieldName
                from dbo.tablename
           ) x
            pivot 
            (
                 max(amount)
                for FieldName in (' + @cols + ')
            ) p '


execute(@SQLquery)

Comments

Popular posts from this blog

How to Convert Word Document to PDF using C#

How to Get First Day and Last Day of a Current Quarter in SQL Server