Bruce:

Yeah, I see the problem. You need a row number or some other unique identifier(s) to tie them together, and if you don't have that in...

Bruce, check out the OUTPUT clause to an INSERT. You can trap ALL the recently generated IDs from the mass INSERT, not just the last one, into...

1. Bruce is absolutely right. If possible, rethink this whole idea of writing the code on the fly in your UI. That approach will...

You're very welcome. I just hope they are the right cust_ids 😉

Absolutely! I've never had a problem seeing the harm to people,...

Not only that Roy, but I've seen questions on here that read something like this:

"I've just deleted some huge, important tables and I haven't been doing backups. How...

Cardinal Moden will call me a heretic, yet I beg to differ with respect to the word "ALL"....

Bruce, I would guess not, since noeld asked that question earlier. But the question bears repeating.

Looks good to me, if it looks good to you. 😀

The tally table was totally unnecessary to the solution, but I included the article reference in case anyone...

I started out in Hugo's camp. I'm always glad to have learned a new function, but one thing I can't get away from is that, in the...

This is why I think interview questions should just go unanswered, even deleted. There's no telling how much damage is done to companies that are foolish enough...

Milan... I don't see a UNION ALL.

It doesn't matter if all the lines are being generated by the user interface at one time or not,...

So are we ever going to see the mysterious INSERT statement or not? 😉

I'll read the article, but the fact remains that...

Yes it can.

This solution doesn't involve a tally table, I just used it to set up the test data. But if you don't have one look...

I don't see anything odd about your schema at first glance.

Do you have indexes on the columns used as foreign keys?

Does the asp.net code generate an INSERT statement for each...