I have the following sp.
Basically I am trying to pass in some xml and will then extract from this into a temp table but at the moment doing a simple select * from is bringing back results I don't understand, this is the first time I have used openxml so would be good if someone could explain and tell me what I am doing wrong.
The results are in an attached spreadsheet.
Thanks in advance. eg.xls
ALTER PROCEDURE dbo.SP_Get_685_Report
DECLARE @idoc INT
EXEC sp_xml_preparedocument @idoc OUTPUT, @LINEIDXML
FROM OPENXML(@idoc, '/xml',1)
EXEC sp_xml_removedocument @idoc