Hi All,
Can anyone show me how to do a calculation in stored procedure? What I want to achieve is:
Employee has a different commission on each order, but what I would like to get is the total commission for all the orders that he/she accomplished so far.
Can anyone help me to write a query for this?
Thanks in advance.
Anyone please...|||Try something like this:
SELECT EmployeeID, SUM(Commission) AS TotalCommission FROM yourOrderTable
GROUP BY EmployeeID
|||Thanks, I got it. I was thinking too complicated.