You can send the entire XML to the stored procedure, then parse it in the stored proc using \”OpenXML\” (which basically parses the string into an XML Document object and then uses the xpath inside the stored proc to process it). Just do a google search or SQL Books Online on \”OpenXML\” to learn more. We actually used it for the first time about two months ago.
Neal Waltes