Using output of one select query as input for another

Question

I have an employee table which includes ManagerID as a foreign key. To get the currently logged ManagerId on Employees, I use a statement like -

SELECT MgrId FROM Employees WHERE EmpId=@EmpId

@EmpId is currently Logged on Employees.

I need to get the currently logged on employees manager and the manager's manager in one statement. This involves using the output of the above statement as input of another select statement. I am unsure how to do this. Any help is much appreciated.

Look up for CTE : you'll do something like "With Manager (man) as (select MgrId from Employees WHERE EmpId=@EmpId) " then you can use the column man as a criteria in the following statement — P. O.
– P. O., Commented May 13, 2015 at 11:35

Sébastien Sevrin · Accepted Answer · 2015-05-13 11:35:07Z

2

Assuming your Employee ID field is named Id

SELECT e.Id [EmployeeId], e.MgrId [ManagerId], m.MgrId [ManagerManagerId]
FROM Employees e
LEFT JOIN Employees m ON e.MgrId = m.Id
WHERE e.EmpId=@EmpId

answered May 13, 2015 at 11:35

Sébastien Sevrin

5,4132 gold badges25 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using output of one select query as input for another

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related