Hi makumbi,

Refer below links.

Convert Rows To Columns and Calculate Sum using dynamic Pivot query in SQL Server

Calculate Sum using GroupBy and Pivot function in SQL Server

Please help this is what i have managed to come up with

DECLARE @cols AS NVARCHAR(MAX)
DECLARE @query AS NVARCHAR(MAX)
select @cols = STUFF((SELECT ',' + QUOTENAME(Dates) from Paytemp  as t1
GROUP BY Dates ORDER BY Dates FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)'),1,1,'')
set @query = ';WITH CTE AS(
                    select amount,Dates,Names, admno
                    from paytemp
                )
                SELECT SUM(amount) amount,Names,' + @cols + ' from CTE   
                pivot(max(admno) for Dates in (' + @cols + ')) p
                GROUP BY Names,' + @cols + '
                 '        
execute(@query);

this is what i would want to display

Use this.

DECLARE @cols AS NVARCHAR(MAX)
DECLARE @query AS NVARCHAR(MAX)
select @cols = STUFF((SELECT ',' + QUOTENAME(Dates) from Paytemp  as t1
GROUP BY Dates ORDER BY Dates FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)'),1,1,'')
set @query = ';WITH CTE AS(
                    select amount,Dates,Names, admno
                    from paytemp
                )
                SELECT Names,' + @cols + ' from CTE   
                pivot(SUM(amount) for Dates in (' + @cols + ')) p
                GROUP BY Names,' + @cols + '
                 '        
execute(@query);