Thank you for the replies...

@jeff

In case you're interested, I have attached the tables schema. For what it's worth, the only reason I was considering going the XML route...

WOW! You guys (and girl) are good!

I implemented the temp table suggestion as well as substituting the sub-query for a JOIN and viola... 800 records in 1 sec. I intended...

@jeff

Thanks for the response. That was what I suspected.

Same question, different scenario. What happens when one issues two separate INSERT statements in a single batch? For example:

INSERT INTO...

Great article! Lots of good info.

I have a question about Tip #3. I understand that the TRIGGER will only fire once per batch... does an INSERT INTO with a SELECT...

I understand using the "sa" (or equivalent) account is bad.... really bad! If that was our only design flaw, we'd be good shape 😉 But I digress. I did in...

@Ian and @jeff - EXCELLENT detective work! Indeed both posts are mine. I figured it was valid since one was regarding design and the other about indexing. Thank...