Yes, Lowell, I really do see your point. A view like this also spares one the need to create a second trigger for when an invoice is deleted, which...

Well, thank you for that. This is a text book example. I am learning triggers and it is Peter Rob and Carlos Coronells sample databases and questions I am...

So, I tried Lowell's script (where a table called MyAlias is pulled 'voila' out of thin air. Unsure :unsure:) never seen before:w00t:)

Bug is still there. Both 1002 and 1003...

I took David's answer because it used my existing column names and was less confusing to me.

That trigger works....but has a bug. It updates both 1002 and 1003. ...

Read it. Thanks.

Want to give everything a label, right now, memorize, and then draw on these from memory like tools from a waist belt... So, the first query utilizes as subquery, the...

Thank you so much. I can't believe how good you guys are to me. I am learning here.

Celko, I would like to read your books, but now I'm afraid that it will feel like you're yelling at me, and I usually have a voice in my head...

Hello Celko,

I can see how the points you make are important when it’s your task to design a database, but that is not what I am focusing on here....

roryp and Paul, the CTE solution provided works great. Thanks.

Actually, the above CTE solution is the tool for the job for my other posting:

http://www.sqlservercentral.com/Forums/Topic1240528-392-1.aspx#bm1240564

For this scenario, using a CTE seems out of place.

Paul, I feel the love.:hehe: I now understand that a CTE is the tool for this job.

Thanks for the Anatomy and Physiology of CTE based queries. I studied...

Burninator, why are you going all sophisticated on me?

OK, this is accurate. For the forum I left it with line table because the line_prices and the p_prices are the same and I didn't want to provide more...

OK, Paul, I appreciate it very much.