Thanks Sergey.. it really doesnt make sense to me why the other way didnt work.. anyway.. another question.. it wount let me have any properties in the root element.. ex

<ArrayOfString xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="https://secure.mio.uwosh.edu/webservices/">

Do I have to parse these out before I sent it to the sql server?? Is there some way I can tell the server to ignore it?



>Hi Eric,
>
>This works for me

select * from openxml
>  (@idoc, '/ArrayOfString/string', 2) WITH ([string]  char(16) '../string')

>>im trying to get the following code to work.. but it just keeps returning the first row...
>>
>>

>>declare @spXML as varchar(1000)
>>set @spXML = '<ArrayOfString>
>>  <string>0002A5FF6ECC</string>
>>  <string>000393ED2634</string>
>>  <string>000A95895CE4</string>
>>  <string>000BCD022EAE</string>
>>  <string>000D28975D26</string>
>>  <string>00508BFBE766</string>
>>  <string>0090F514003C</string>
>>  </ArrayOfString>'
>>
>>DECLARE @idoc int
>>EXEC sp_xml_preparedocument @idoc OUTPUT, @spXML
>>select * from openxml (@idoc, '/ArrayOfString', 2) WITH ([string]  char(16))
>>

>>
>>any ideas?
>>
>>