>I don't know a lot of concepts you used in your cte example. Hence, the reason to stay with what I know.
>
>Now, that I see the blueprint of how to use the Update and Select, I will try to modify your code to make it do other things I was looking for. Like, getting a Unit Price of the found record and reducing the value of @QtyUse (by what is "taken" from qty_left).
>
>Again, thank you.
>
>
Take a look at the OUTPUT clause of UPDATE command.
If it's not broken, fix it until it is.
My Blog