I found the solution and it is working fine. Still to undergo testing. But I think, it is works as expected.

Hi,

Did you understand the calculation.

Does anyone has any approch for this calculation?

Yes, calcuation has changed from the first post. I did not understand lmm_value means. Yes the values are from MS-Project.

The value of Task 1 is obtained from its children -...

Thanks a lot for coming forward to help. I really appreciate that. Here are the insert statements. And the values I pass to procedure is (21,20,5). Please let me know,...

Now, I am thinking, the correct way is to pass the paramenters for Heighest id_father and its corresponding Id_task and level_task.

Sorry, I accidently posted without comments.

the last value in the each row is the intermediate result. In the procedure I will pass the parameters as Heighest level and its id_father...

id_taskid_fathertasklevel_taskduracion_taskpercent_taskname_task

11176NULLTask 125

21260NULLTask 1.138

3232100Task 1.1.1100

42338NULLTask 1.1.244

54410100Task 1.1.2.1100

6442220Task 1.1.2.220

744535Task 1.1.2.335

844140Task 1.1.2.440

92320NULLTask 1.1.320

10942020Task 1.1.3.120

11129NULLTask 1.239

1211320Task 1.2.10

131137NULLTask 1.2.250

14134250Task 1.2.2.150

15134550Task 1.2.2.250

1612100Task 1.30

1712200Task 1.40

18126NULLTask 1.510

191836NULLTask 1.5.110

201946NULLTask 1.5.1.110

21205610Task 1.5.1.1.110

Final result should be 25 or 25.37 to be precise. This the sample table data. Task is calulate the value of root of the tree that is Task1(First row) by...

Table looks like below. For Ex. row 3, Id_task = 3, level_task=3 menas it is at level 3, id_fathertask = 2 that means, its parent is the one which has...

Thank you so much for your response. I am sorry for changing the code.

I cannot combine two update statements, since I need the first update value to calculate the next...

Thanks a lot. However, the requirement got changed and had to modify the procedure. This is the proc

alter Procedure GetCalculationForTestData

(

@taskId int,

@fatherId int,

@taskLevel int

)

as begin

Create table #TestFinal

(

id_task int primary...

Thanks, I am going through your link.

But we can pass the parameter for the function.

Thanks for your response.

Well, I am trying to have a recursive function for the below calculation

Calculation starts fromt the last task 1.5.1.1.1

(level_task*duaration_task) + percent_task (5*6)+10 = 40

the result goes to...

Hi,

Thanks alot for the suggestions.

The table already had identity column, SSIS inserts the data to this table every week. but it was not following the sequence which i...

Hi Lynn Pettis,

I guess the data is inserting in differnt order due to page split. Do we have any options there, I dont know much of page split.

Regards,

Suhan