Cadavre,

Thank you for your help.

What I expect as a result is to update the "Product" table, on the column "qtt_terminal".

Here is a picture with example output data based on input...

Hey.

For test purposes, I'd made the same logic but using dynamic sql. And the query is faster than the queries posted here. Can someone explain this?

Best regards,

Marco Alves.

THANKS A LOT!!!

ok. I get it.

But, a suggestion: Some boards here are correlated, like programming adn development.

I think that should exists an option to post some thread to more than one board. Not...

how I can finish a thread?

for the last error install sql sp4