You haven't defined the relationship between the table that you are updating and the source data, so it's as if you're updating every single row in the table with every...

And instead of using MONTH() try using DATEPART(QUARTER, <yourdatefield>)

Drew

Here is an alternate method that does not require a pivot.

SELECT
*
FROM OPENXML(@hDoc, 'appt_links/appt_link',1)
WITH
(

[ResourceID] [nvarchar](10) 'Field[@name="ResourceID"]',
[FromActivityID] [nvarchar](10)...

My solution is to use the right tool for the job.  In this case it's a reporting tool such as SSRS.

Drew