You can write a Stored Procedure which can do this.
DECLARE @iDoc INT
DECLARE @XML VARCHAR(MAX)
set @XML = '<ResultsDS>
<Results>
<Yesno_Vote>NO</Yesno_Vote>
<PollPosition_1>person1</PollPosition_1>
<PollPosition_2>person2</PollPosition_2>
<PollPosition_3>person3</PollPosition_3>
<PollPosition_4>person4</PollPosition_4>
<PollPosition_5>person5</PollPosition_5>
</Results>
</ResultsDS>'
EXEC sp_xml_preparedocument @iDoc OUTPUT, @XML
INSERT INTO YourTable
SELECT *
FROM OPENXML(@iDoc,'/ResultsDS/Results',2)
WITH (Yesno_Vote varchar(50) 'Yesno_Vote',
PollPosition_1 varchar(50) 'PollPosition_1',
PollPosition_2 varchar(50) 'PollPosition_2',
PollPosition_3 varchar(50) 'PollPosition_3',
PollPosition_4 varchar(50) 'PollPosition_4',
PollPosition_5 varchar(50) 'PollPosition_5'
)
EXEC sp_xml_removedocument @iDoc
I assumed the data types to be
varchar(50)
, change them according to your table's properties.