OpenXml question

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 1

Try changing

SELECT Id FROM

OPENXML(@idoc, '/Ids', 2)

WITH( Id int )

to

SELECT Id FROM

OPENXML(@idoc, '/Ids/Id', 2)

WITH( Id int '.' )

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

maieras.andrei SSC Enthusiast Points: 198 More actions · Answer 2

SSC Enthusiast

Points: 198

January 21, 2015 at 8:44 am

Now I don't get any result...

Thanks for answering

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 3

What happens when you run this?

DECLARE @fileIds Xml =

'<Ids>

<Id>1</Id>

<Id>2</Id>

</Ids>',

@archiveName varchar(255),

@idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @fileIds

SELECT Id FROM

OPENXML(@idoc, '/Ids/Id', 2)

WITH( Id int '.' )

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

maieras.andrei SSC Enthusiast Points: 198 More actions · Answer 4

Very strange the code now looks like this as you replied first time

(SELECT Id FROM

OPENXML(@idoc, '/Ids/Id', 2)

WITH( Id int '.')) AS s

ON f.FileId = s.Id

I made some changes but undo to what you said and now seems to work

I'm confuse can you explain please what '.' does?

Thanks a lot