Copy/paste the query and run it
Commenting out
--join
--OPENXML (@DocHandle, '/customers/employee',2)
-- WITH ([employee name] varchar(50) 'name',
-- [employee id] varchar(50) '@emp') g
--on w.[customer name]=g.[employee name
should give you
in the query we have @emp and @cust; the reason we put @(amp) is because we use it when the field is inside the tag. It is case sensitive.
if you use the exact name as the tag like in( id )you do not need to type the node after( int)
I hope this script is helpfull..
