DECLARE @TempTable TABLE
(
    id INT,
    XmlColumn xml
)

INSERT INTO @TempTable
VALUES (1, '<root><element>ID 1 Text 1</element><element>ID 1 Text 2</element></root>')

INSERT INTO @TempTable
VALUES (2, '<root><element>ID 2 Text 1</element><element>ID 2 Text 2</element></root>')

SELECT id, C.VALUE('.', 'varchar(max)') AS ElementText
FROM @TempTable temp
CROSS apply temp.XmlColumn.nodes('/root/element[sql:column("id")]') AS T(C)