Smash125 (9/2/2012)
Just curious to know that i am not getting it
NP. The following will do the exact same thing as your query. All I did was remove the outer SELECT.
DECLARE @OrdNum varchar(5)
DECLARE @Empid int
SET @OrdNum='XZ1'
SET @Empid=200
SELECT OrdNum,Empid,Mgrid,MgrLevel FROM #Orders
WHERE OrdNum=@OrdNum AND Empid=@Empid
--Jeff Moden
Change is inevitable... Change for the better is not.