SELECT AC_HHOLD, [2012042],[2012043],[2012044],[2012045],[2012046],[2012047],[2012048] FROM (
select FILENAME, AC_HHOLD, COUNT(*) AS TRIPS
from PURCHASE
where AC_barcode='B'
GROUP BY FILENAME, AC_HHOLD
) as a
PIVOT
(MAX(TRIPS) FOR FILENAME IN ([2012042],[2012043],[2012044],[2012045],[2012046],[2012047],[2012048])) as T
select FILENAME, AC_HHOLD, COUNT(*) AS TRIPS
from PURCHASE
where AC_barcode='B'
GROUP BY FILENAME, AC_HHOLD
) as a
PIVOT
(MAX(TRIPS) FOR FILENAME IN ([2012042],[2012043],[2012044],[2012045],[2012046],[2012047],[2012048])) as T