locked
How to get Hierarchy of employees in sql server 2008? RRS feed

  • Question

  • I have Employee database , now I  want to get all the employees which are comes in hierarchy for reporting purpose

    Let me know any feasible solution.

     

    Thanks

    Monday, January 24, 2011 6:50 AM

Answers

  • the MS SqlServer forum (http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads ) would be the right forum to post such questions.

    If the rows in table has self-reference RI, you can at least write a simple app to build up the hierachy by yourself, however, do ask the guys in the reporting service forum as I provided above.

    thanks

    Yunwen


    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Yunwen Bai Wednesday, January 26, 2011 8:58 PM
    Wednesday, January 26, 2011 8:58 PM

All replies

  • please give me reply asap?

     

    Thanks a lot.


    prakash
    Monday, January 24, 2011 11:16 AM
  • the MS SqlServer forum (http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads ) would be the right forum to post such questions.

    If the rows in table has self-reference RI, you can at least write a simple app to build up the hierachy by yourself, however, do ask the guys in the reporting service forum as I provided above.

    thanks

    Yunwen


    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Yunwen Bai Wednesday, January 26, 2011 8:58 PM
    Wednesday, January 26, 2011 8:58 PM