Re: (ot) insert soap xml nodes to MS SQL table problem

> I'm having some troubles getting around the soap header and xmlns part > inGetResponse in something like the following example where it can't find > data for the member nodes. ... This is a namespace problem. I don't know the exact answer offhand, but if you query "ms sql xml namespace" you'll

(ot) insert soap xml nodes to MS SQL table problem

Hi, I'm having some troubles getting around the soap header and xmlns part inGetResponse in something like the following example where it can't find data for the member nodes. declare @UserInfo table (InfoName nvarchar(100), InfoValue nvarchar(100)) declare @xml xml set @xml = ' http://sc