Table Value Constructors solution for question 8528061

Please login or register to vote for this query.

(click on this box to dismiss)

- http://stackoverflow.com/questions/8528061/

Q&A for programmers

CREATE TABLE #tblEntity
( ID INT
, Name CHAR(10)
) ;

INSERT INTO #tblEntity
(ID , Name)
VALUES
( 1 , 'One') ,
( 2 , 'Two') ;

SELECT t.ID, t.Name, o.Ordr AS "Order"
FROM #tblEntity AS t
  JOIN
    ( VALUES
         (1,2)
       , (2,1)
    ) AS o(ID, Ordr)
    ON o.ID = t.ID ;

created dec 15 11