How to get Employees Hierarchy

vandana 0 Reputation points
2024-09-30T17:48:51.62+00:00

Hi,

My requirement is as follows: I would like to obtain Employee Wise Hierarchy (Bottom Employees to Top Employees) using SP.

Note (Role): NH is Level-1(Top Level) VH is Level-2 AVP is Level-3 RM is Level-4 DRM is Level-5 BM is Level-6 TH is Level-7 FLS (Bottom Level)

My Table:

My table contain All employees ID, all employees name, designation, along with their manager name and manager id

this is the reference image which i used in SQL As well as in power bi but i did'nt get the answer please suggest User's image

OUTPUT should be like this

User's image

NOTE( if the BM reports BM so we need to move BM2 in next column And this stituation is same as in TH )

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
170 questions
Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
55 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
825 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,632 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.