var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I've run into a problem using openxml and would greatly appreciate any help or direction!
The Xml document I am working with contains the following excerpt:
My problem is this: There can be a variable number of line elements (between 2 and 5), and in addition each element tag is identical to the others, i.e. Line.
I am trying to populate a SQL Server 2000 table (which contains the columns AddressLine1, AddressLine2, etc.) using OpenXML
Here's the code for my sproc....
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
FROM OPENXML (@idoc, 'root/data/', 2)
WITH (Number int '//no',
// address line detail here
Postcode varchar(10) '//PostCode')
I'm ok with OpenXML/sp_xml_preparedocument syntax and that, but I can't think how to handle unknown multiple address lines with the same tag name!
ANY HELP GREATLY RECEIVED!!!!
only thing that I can say is that whatever builds the XML, the need to supply all the tags that match your definition
For anyone who might stumble upon this, I found the answer here.