Hi Aaron,

Thanks for the solution. Actuly depending upon this heirarchy i am going to calculate the start and end dates of tasks when end date is closed. If the entry...

Hi Aaron,

Thanks for quick reply.

I have data as follows which is related to tasks schedule.

ContractDateIDPredecessorContractDateID

570NULL

572NULL

574NULL

576NULL

578NULL

580NULL

582NULL

584NULL

586NULL

588NULL

596NULL

604NULL

605NULL

606NULL

607NULL

608NULL

609NULL

610NULL

611NULL

612NULL

613NULL

614NULL

615NULL

616NULL

617NULL

618NULL

619NULL

620NULL

621NULL

622NULL

623NULL

624NULL

625NULL

626NULL

627NULL

630NULL

601NULL

590NULL

597570

598570

592570

571570

573572

592572

599574

575574

577576

592576

595576

602578

579578

581580

602580

602582

583582

585584

592584

592586

587586

589588

599588

592590

591590

593592

594592

599592

600599

602599

603602

hierarchical recursive query is as follows

;WITH DatesHierarchy(ContractDateID, PredecessorContractDateID, HLevel) AS

(SELECT ...