• You can still cross tab or pivot, but you will need to use dynamic SQL.