thanks u very much for u'r guidence..

thanks for giving reply. in result i want

-----------------------------------------

actuals/budget | Revenue | Month | year |

------------------------------------------

Actuals |100 ...

hi Adi

thanks for the quick reponse i will try and let u know and if any help i will ping u .

thanks

hi Adi

thanks for your reply with a solution. i am starter in SQl Server so can u please help me.

i have the following needs

1) i get thousands of...

Explanation:

Top Most Parent Childs level

OB000274 OB000033 ...

hi check the below query given

the query will gives u all the childs corresponding to the parent and the level also.

WITH eqstruct (level, eq_nmr , eq_parent ) AS

...