PiMané (9/20/2013)
Jeff Moden (9/20/2013)
Heh... you asked what the best way to store XML is. I suggested shredding it and storing it in normalized tables. Are you storing the XML in a table or not?Right 🙂
I don't store the XML in the database... I send the XML to SQL to process it. My question in how to store XML is cause it's used by several SPs and have to "pass" it between them...
Pedro
I wouldn't store it. Build a main "control" proc that parses it once and stored it in a Temp Table and have the other stored procedures use the data from the Temp Table.
--Jeff Moden
Change is inevitable... Change for the better is not.