>>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.
I will. But I need to create this SP - completely - by Tuesday or Wednesday. I will probably mess up anyway, but if I work with new concepts, I will mess up for sure :)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham