How to calculate the commision of the member?

Question

In SQL 5 members are register the 1st member will refer the other 4 so we put commision as 1st member got-50% other 4 members got-10% how i calculate it?

Bhabani prasad Dash · Answer

from 5 member suppose if ist member give a client to the company then company give to ist member 10% directly of investment of client money and 6432% to respective member respectvely or if second member give a client to the company only 3rd fourth fifth will get 432 % directly.how i will calculate using c# or sql server

Pardeep Malik · Answer

hello bhuvana you can create a trigger or store procedure for that Let we have a table to insert amount to the table of customer and as you enter the amount value also reflects to commission table. as create trigger com1 on custmor for insert as declare @amt float select @amt=amount from inserted ----amount is the column for inserting amount in customer table declare @m1com float declare @m2com float declare @m3com float declare @m4com float declare @m5com float set @m1com=@amt*50/100 ---Calculating commission for 1st memeber set @m2com=@amt*10/100 set @m3com=@amt*10/100---Calculating commission for other memebers set @m4com=@amt*10/100 set @m5com=@amt*10/100 inset into commission1 values(.....@m1com@m2com@m3com@m4com@m5com....) ---adding commission of memebers with other values in table Note - Trigger automatically called when value is ineserted

Muhammad Shahid Farooq · Answer

Kindly explain you question and also mention the table with column so we can give you exact solution.

Kunal Vaishya · Answer

How you linke the person so we can get Level of Members