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) 'Field[@name="FromActivityID"]',
[FromActivityDate] [datetime] 'Field[@name="FromActivityDate"]',
[FromActivityRouteID] [nvarchar](10) 'Field[@name="FromActivityRouteID"]' ,
[ToActivityID] [nvarchar](10) 'Field[@name="@ToActivityID"]',
[ToActivityDate] [datetime] 'Field[@name="ToActivityDate"]',
[ToActivityRouteID] [nvarchar](10) 'Field[@name="ToActivityRouteID"]')
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA