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)) >>