Okay, I have a particulary ugly block of xml that I need to parse out and stick into sql server.
The challenge is getting this thing into the correct format since it has both element and attribute
peppered in it. I was just going to use a dataset and read the xml into it. But there are some problems
with that because the repeating <geo_co> tag in mail and residence address blocks gum up the works.
Anyone point me in the right direction? I have started to sort it out, but the voting regions return a
very strange row, this one has me baffled, I spent the better part of a day futzing with it. Any help would
------------[ Cut Here ]--------------------
DECLARE @IDOC INT
DECLARE @DOC VARCHAR(4000)