That does not really seem to fit the shoe..

INSERT INTO #Results(ResultsXML)

SELECT * FROM [SomeDB].[dbo].[Customer] WHERE Custid=1 FOR XML PATH('')

Msg 6819, Level...

That is correct, so the conclusion is that i should create a two column width temp table

First column IDENTITY,

Second column, containing the XML string

Would that be the right way?

That was just an example (therefor in --comment, on the first line). It basically can be anything.

I dont think i can create a temp table without knowing what columns (number/type) there are on forehand, can i?