hi sravanthi,

here is the query

select InstallationName

,FiscalYear

,[what is the reason for install?]

,[reason id]

,[install start date]

,[install end date]

,[install status]

,[Do you feel the install is incomplete?]

,[Is the expiration of 90 days exceeded?]

from (select

InstallationName

,FiscalYear

,Question

,Answer

From myQuestionTable ) P PIVOT (Max(answer) for Question in

([what is the reason for install?]

,[reason id]

,[install start date]

,[install end date]

,[install status]

,[Do you feel the install is incomplete?]

,[Is the expiration of 90 days exceeded?])) as PVT