Thanks Lowell !

How can I do it without looping through years?

They dynamically generate column names ('Nov 2012', 'Dec 2012')

in the loop.

'Nov 2012' = Isnull((SELECT Sum(comm)

FROM xxxx_ni_monthly_comm_booking

WHERE ni_flag = 0 AND year_number = 2012 AND month_number = 11