SELECT t.* 
FROM @T t
JOIN (VALUES (1,'XYZ'),(2,'AAA'),(3,'PQR')) lst(rn,name)
ON lst.name= t.name
ORDER by lst.rn

DECLARE @T TABLE(ID INT,NAME VARCHAR(10)) 

INSERT INTO @T VALUES(1,'PPP')
INSERT INTO @T VALUES(2,'AAA')
INSERT INTO @T VALUES(2,'ZZZ')
INSERT INTO @T VALUES(3,'XYZ')
INSERT INTO @T VALUES(4,'PQR')
INSERT INTO @T VALUES(5,'ZAB')

DECLARE @T_INPUT TABLE(ID int IDENTITY(1,1) , NAME VARCHAR(10)) 

INSERT INTO @T_INPUT VALUES('XYZ')
INSERT INTO @T_INPUT VALUES('AAA')
INSERT INTO @T_INPUT VALUES('PQR')


/* SELECT * FROM @T WHERE NAME IN('XYZ','AAA','PQR') */


SELECT AA.* 
     FROM @T AA,
          @T_INPUT BB
     WHERE AA.NAME=BB.NAME
ORDER BY BB.ID