DECLARE @XML XML

SET @XML = CAST('<DocumentElement>
	<QuestionList>
	<QuestionId>Q1000</QuestionId> 
	<Title>Apple</Title>
	<Sequence>3</Sequence> 
	<MergeSequence>1</MergeSequence> 
	</QuestionList>
	<QuestionList>
	<QuestionId>Q1028</QuestionId> 
	<Title>Banana</Title>
	<Sequence>3</Sequence> 
	<MergeSequence>2</MergeSequence> 
	</QuestionList>
	<QuestionList>
	<QuestionId>Q1029</QuestionId> 
	<Title>orange</Title>
	<Sequence>3</Sequence> 
	<MergeSequence>3</MergeSequence> 
	</QuestionList>
	</DocumentElement>' AS XML)

SELECT x.xml.value('QuestionId[1]','VARCHAR(5)') As QuestionID
	,x.xml.value('Title[1]','VARCHAR(10)') AS Title
	,x.xml.value('Sequence[1]','INT') AS Sequence
	,x.xml.value('MergeSequence[1]','INT') AS MergeSequence
FROM @xml.nodes('//DocumentElement/QuestionList') x(xml)