May 11, 2010 at 11:39 pm
Are you looking to build the compensation plan, just calculate PV, or build the binary tree? Or are you looking for somebody to do all of that for you?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 11, 2010 at 11:44 pm
i am looking for the coding i am a developer
May 11, 2010 at 11:51 pm
The code for which one of those areas that I listed?
Can you provide samples of what you have done so far?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 11, 2010 at 11:59 pm
i didnt yet start i dont even know how to start
May 12, 2010 at 12:04 am
I recommend you hire a consultant to help you with it. The compensation plan, IMO, would be best done in a .Net language. The PV calculation would need to be calculated in order to figure out the compensation plan. In order to calculate PV, you have to build your binary tree. The binary tree could be done in TSQL, while the PV calculation may need to be done in both languages in order to cover different requirements (i.e. calculate the compensation plan or simply display current pv based on a cached tree).
All of this is far more than just a simple exchange through the forums.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply