Luiz,

Pardon my angst today. I have been trying for weeks to get a simple PIVOT example and nothing is working. I have been on multiple posts, but cannot seem to get this working. Could you please take a quick look at the syntax below and let me know if this looks correct to you.

Thanks for all your help and apologies for my mood.

select [0] AS Monday,

[1] AS Tuesday,

[2] AS Wednesday,

[3] AS Thursday,

[4] AS Friday

from (select * from #MnthCustSvcAVGCallsOfferedByINT) as src

PIVOT (sum(AVGCallOffered) FOR Interval IN ([0],[1],[2],[3],[4]))