Hope this helps. The indents are where they are supposed to be indented. I will attach some sample data for you to use shortly.

Unique ID ...

Close but your using the CurrentProcessStepID as the level guage. There may be more then one CurrentProcessStep of Sort (2) so this would not allow the higharchy to match...

Spoke to soon.

There is one minor issue. Once again the UniqueID in not important just that it be unique and the Level is linked to the Parent UniqueID with...

The current process step really has no function in the sort except in the following situation.

Recieving

Sort

Teardown

Recycling

Test & Diagnostics

...

The level indicates that how far down the process it is.

So for example

Recieving Level null

Sort Level 1

Tear Down Level 1

...

It's the primary key from my tree view in the jpg above.

This has to be unique but can be any value.

After thinking about this more last night is it even possible to get the level and UniqueID to function as they do in the correct results above.

I'm having...

The issue is with the last line of code.

SET @WorkingDays=(([@MonthDays]-([@LWOP]+[@Absent]*(2)))-((([@CasualLeave]+[@CompensatoryLeave])+[@DutyLeave])+[@VacationLeave]))

Remove the brackets [ ] around the variable names.

SET @WorkingDays=((@MonthDays-(@LWOP+@Absent*(2)))-(((@CasualLeave+@CompensatoryLeave)+@DutyLeave)+@VacationLeave))

Thanks for your help. Everything works but one thing. I need the Level to show the results from attached results.xls file. I have your query and mine...

I have added the sample output and dummy data that can be used. When you run the stored proc you can use

EXEC GetCategoryList @LotNumber=30447

I have also changed the rar...

Sorry about that I have added the supporting documentation. If there is anything else you need from me please let me know. My clients is freaking out.

Thanks,