Home Forums SQL Server 2008 SQL Server Newbies Pivot over multiple columns using the 1.1, 1.2, 2.1, 2.2 sequence RE: Pivot over multiple columns using the 1.1, 1.2, 2.1, 2.2 sequence

  • Luis, once again thank you for your help. The revised code works flawlessly in my application now. In a gridview, the TestType is now highlighted in the SampleNo row when the Complete_Date is not NULL. Perfect!

    And I did add the DateAndTime, Comments1a fields (I removed them from the test code to abbreviate somewhat).

    --Larry