Need help with a stored procedure. I need to query one table get the result and update another with it.
I need to query a Sales table get the SALESMAN with the MOST sales - MAX(SALES)
Then take that value and update the TOPSALES man Table with that amount for that given SALESMAN.
Need the SQL to save the result to a var ... take that var and update another table