yeah, you need to fenagle with the path, I'll check it out reall quick.

Updated sql select

SELECT *

FROM OPENXML (@docHandle, N'/hearingData/employees/employee',2)

WITH (employeeID nvarchar(50) 'id'

,EmployeeLName nvarchar(50) 'name/last'

,EmployheareeFName nvarchar(50) 'name/first'

,EmployeeMName nvarchar(50) 'name/middle'

,EmployeeStatus nvarchar(10) 'status'

,EmployerID nvarchar(20) 'employer/id'

,EmployerBillingCode nvarchar(20) 'employer/billingCode'

,EmployerSiteCode nvarchar(20) 'employer/siteCode'

)

the xml nodes are case sensitive, billingCode, and siteCode were not exactly right. 😉