<pre>
DECLARE @sqxml XML, @xid INT;
SET @sqxml= '<education>
<Type scienceid =''16'' nonscienceid=''51'' class=''A''/>
<Type scienceid =''18'' nonscienceid=''50'' class=''B''/>
<Type scienceid =''16'' nonscienceid=''50'' class=''C''/>
</education>';
exec sp_xml_prepareDocument @xid OUTPUT,@sqxml
;WITH CTE AS(SELECT * FROM OPENXML(@xid,'education/*')
WITH (scienceid VARCHAR(10) '@scienceid',
nonscienceid VARCHAR(10) '@nonscienceid',
class VARCHAR(10) '@class'
)
WHERE scienceid=16
)
SELECT * FROM CTE