Mark,
I'm not aware of any SQL functions or SP's that will do what you need to do, but then I'm not a SQL expert either. As I mentioned in my previous post, I'm betting that you can do what you need to do with SQL Server's new XML capabilities. You'd basically have an SP that accepts an XML string (which would be the XML from your DataSet). I just haven't used it, so I can't give you any particulars. Trying looking up some stuff in BOL (Books Online).
As far as posting my PUT SP's, I'll do that in a couple of hours, since I don't feel like posting it from memory off the top of my head (that always gets me in trouble <g>). My work laptop is shut down right now, and I won't be starting it back up until I get to the office. BTW, we automatically generate the SP's using a VFP utility prg that we wrote. So, everytime a table schema changes, as long as we remember to run the utility, we keep our SP's in sync with the table. It's fairly painless. <s>
Be back in a coupla hours...
~~Bonnie