How to write this recursive query correctly in the SQL Server?

Question

I write a recursive query. Problem: a recursive query that show chain management employees that leads to a particular employee('Maria Cameron' with empid=8).Output should be like this:

and HR.Employees is here:

and my query is here:

with Managers as
(

SELECT empid, mgrid, firstname,lastname
FROM HR.Employees as h
where mgrid IS NULL
UNION ALL
SELECT e.empid,e.mgrid,e.firstname,e.lastname
FROM HR.Employees as e INNER JOIN Managers m 
ON (e.mgrid = m.empid)
)
 SELECT *
 FROM Managers
 where firstname='Maria' and lastname='Cameron' and empid=8

but this query don't operate correctly and my output is:

"but this query can't operate correctly." -- can you elaborate? What is not working correctly? — rory.ap
– rory.ap, Commented Nov 30, 2015 at 14:04

Arion · Accepted Answer · 2015-11-30 14:11:34Z

1

This line here is not correct:

with Managers as
(

SELECT empid, mgrid, firstname,lastname
FROM HR.Employees as h
where 
*******

Where what?

WHERE h.mgrid IS NULL

answered Nov 30, 2015 at 14:11

Arion

31.3k10 gold badges75 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

How to write this recursive query correctly in the SQL Server?

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