Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    please give me reply asap?

     

    Thanks a lot.

    prakash
    Monday, January 24, 2011 11:16 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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