MySQL Forums
Forum List  »  Newbie

Re: Converting SQL Server Stored Proc to MySQL Stored Proc
Posted by: Steve Bell
Date: August 17, 2015 02:00AM

Hi Rick

Thanks for the suggestion.

I had to separate the embedded select statement from the update statement and store the result in a temporary table which I then referenced in the rest of the stored proc.

The downside to this solution is the potential risk of 2 users ending up with the same customer as a consequence of splitting the 2 statements.

Steve

Options: ReplyQuote


Subject
Written By
Posted
Re: Converting SQL Server Stored Proc to MySQL Stored Proc
August 17, 2015 02:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.