Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
r_rahardjo14@yahoo.com
Starting Member
1 Post |
 Posted - 2006-09-06 : 15:07:34
|
| Hi All,I am trying to calculate the employees' commission based on the orders that they already completed. Each order may have different commission percentage. How can I accomplished this in stored procedure?In my report I will show the Employee Name, Total Commission and Total Orders.Anyone please help me....Thanks in advance. |
|
|
ronnyr
Starting Member
21 Posts |
Posted - 2006-09-06 : 17:48:28
|
| I got it. Thanks.Ron.“Know where to find the information and how to use it - That's the secret of success” |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-06 : 19:47:40
|
Can you kindly post the solution for others that are also interested in this ?
KH |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-09-06 : 22:35:49
|
| It's two different posters.I think ronnyr just posted on the wrong thread.I think r_rahardjo14 may still need help, but he needs to explain the problem better. There isn’t enough information posted to even know what he is after.CODO ERGO SUM |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-07 : 00:10:11
|
Think it is the same guy. See their profile.
KH |
|
|
|
|
|
|
How to do calculation