• This is a pretty interesting problem. I don't know if this is the best way to handle it, but here's one approach. Let me admit up-front that I've not tried this, but it seems feasible. The only gotcha I see is if the values themselves will contain =, which is addressed below.

    I'd start by creating an XML format file for it and an inbox table to receive the data. Import the file using BULK INSERT into the inbox table. If the = doesn't appear in the values themselves, the inbox table can consist of 2 columns - name and value. If it does, use one column and split the string on the first = in the field. An identity field in the inbox table can help with keeping the sequence of the rows straight.

    Next, delete everything from the table where the name isn't one of the two you need.

    You now have a table of rows containing everything you need. Use the identity field to sort (so things are paired up correctly) and you can insert it from the inbox table into a permanent table for long-term storage.

    Like I said, I've not tried this. If there's a better way, I'm definitely interested in it.