I'd strongly recommend to read this:
Pivot two or more columns in SQL Server 2005[
^]
The author of related article states that you're able to pivot more then one column, but you have to add extra info into pivoted column.
In your case it would be something like this:
equpname q1_pm_Date q1_ActDate q1_doneby q1_reviewby q2_pm_Date q2_ActDate q2_doneby q2_reviewby
Got it?
To achieve what you want to achieve, you need to use reporting tool, which provides functionality to display multiple headers.
More you'll find at
CP Knowledge Base[
^] site.
Submit an article or tip