Smash125 (9/2/2012)
Can be solved using DECLARE and derived columnDECLARE @OrdNum varchar(5)
DECLARE @Empid int
SET @OrdNum='XZ1'
SET @Empid=200
SELECT * FROM (SELECT OrdNum,Empid,Mgrid,MgrLevel FROM #Orders
WHERE OrdNum=@OrdNum AND Empid=@Empid
) AS A
Heh... funny enough, that works for the data given. The given data isn't actually hierarchical data (yet).
You don't need the outer SELECT, though.
--Jeff Moden
Change is inevitable... Change for the better is not.