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 |
|
wkalo
Starting Member
10 Posts |
 Posted - 2005-10-01 : 12:38:11
|
| Hi There I Need A Querry For Commission Sales.I Have 10 Items 7 Items At 2% Of Commission 3 At 4%. Each Salesman Have To reach A Min Of 5000 USD Of Sales Per Month Then All Sales Above That Amount Commission Will Be Calculated. I Need A Querry To Calculate Sales And If Salesman reached The Min Sales, Commission Is Calculated .Any Help ???????Thanks |
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2005-10-07 : 17:07:33
|
| Can this be more specified ? Such as field, table structure, etc ? |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-10 : 02:36:50
|
| and also sample data and the result you wantMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Querry About Sales Commisions