November 9, 2011 at 2:49 pm
Okay folks, here's my situation. A .NET process will be shredding an XML document which will have a list of transactions that will need to be passed to a stored procedure which will insert into a table. There can be N number of transactions and there will be 3 values I will be passed. I can have the .NET application loop over the transactions and call the SP for each one or I can have the .NET application pass an "array" that I will parse in SQL. There is logic to determine which transactions will be passed so you can't just pass the XML document. The current production SQL Server is 2005, so I can't do a table-valued parameter and I'm not sure I would even if I could because of some of the limitations.
What are your recommendations? Loop and 1 at a time or some kind of "array" that I parse in SQL?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 15, 2011 at 8:43 am
Impedance mismatch...there is no right answer. Do whatever is easiest for you to code and maintain, and performs well enough to meet your SLA.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply