Can be solved using DECLARE and derived column

DECLARE @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