How to use Store Procedure for multiple column database update?

5 pts.
Tags:
INNER JOIN
Stored Procedures
I created a store procedure to update a table based on values from another table using inner join. 15 records need to be updated but when the store procedure is executed no rows are updated bu the return value is 0.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your stored proceedure ran successfully, but it did not find any rows that matched your query. Try rewriting the query or give us more details about what you want to update and how you want to update it so we can help you further.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    Also, don't forget to mention what database you are using, and post your code if possible.
    79,925 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: