I have a list id ID numbers contained in an xml document which i pass into a stored procedure.
I want to change the a column to a set value for ALL the id's contained in the xml list, but for some reason I cant get it to work. heres the sql in the stored procedure
EXEC sp_xml_preparedocument @idoc OUTPUT, @_xml
SET StatusID = @UpdateStatus
WITH (id bigint) ox
WHERE Table1.ID = ox.id
EXEC sp_xml_removedocument @idoc
the sp compiles ok and is created, yet when I pass in the xml list, nothing is updated. Can anyone see what im doing wrong here ?
View Complete Post