Home Forums Programming XML Importing XML in SQL Table RE: Importing XML in SQL Table

  • 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