Hi Aravind,

Please find the code for dynamic header choosing in Pivot Table

DECLARE @cols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX)

select @cols = STUFF((SELECT ', ' + Parameter AS [text()]

from lu_Parameter order by Param_ID

FOR XML PATH('')

), 1, 1, '' )

set @query = 'SELECT clientid, studyid, ' + @cols + ' from

(

SELECT clientid, StudyID, Param_ID, Parameter

from lu_Parameter p

) as st

pivot

(

max(Param_ID)

FOR Parameter in (' + @cols +')

) as pvt'

)

select @query