DECLARE@Sample TABLE

(

Data XML NOT NULL

);

INSERT@Sample

(

Data

)

VALUES(N'<bookstore><book><title lang="eng">Harry Potter</title><price>29.99</price></book><book><title lang="eng">Learning XML</title><price>39.95</price></book></bookstore>');

-- SwePeso

SELECTb.n.value('(title)[1]', 'NVARCHAR(MAX)') AS Title,

b.n.value('(title/@lang)[1]', 'NVARCHAR(MAX)') AS Lang,

b.n.value('(price)[1]', 'MONEY') AS Price

FROM@Sample AS s

CROSS APPLYs.Data.nodes('(bookstore/book)') AS b(n);