<p>You can try this:</p> <p> <p> </p> <p>SELECT S.SNAME ,P.PNAME , CAT.COST</p> <p><span> </span>FROM CAT  </p> <p><span> </span>INNER JOIN S ON S.SID = CAT.SID</p> <p><span> </span>INNER JOIN P ON P.PID = CAT.PID </p> <p><span> ...

Solution to TSQL Beginners Challenge 17...

This problem is all about identifying all the employees directly or indirectly to whom the given Employee reports to. The challenge is to write a query that can take a Employee Id as a parameter and list all the employees to whom the Employee is reporti...