SET @XML = CAST(
'
' AS XML)
SELECT
CAST(Filter.Field.query('Campo1/text()') AS VARCHAR(50)) AS Campo1 ,
CAST(Filter.Field.query('Campo2/text()') AS VARCHAR(50)) AS Campo2
FROM
@xml.nodes('/Tabla/Renglon') Filter (Field)
WHERE
Filter.Field.exist('Campo1') = 1