That is perfect! Thanks so much man! I have been spending ages searching for this!

Ryan

Quick update since i have beating my head against the wall on this....

For the data values, I have them working using the following statement:

SET @insValue = @MessageBody.query('data(//Message/_x0023_ins/*)[position()=sql:variable("@LoopCount")]').value('.', 'varchar(1000)')

I cannot get...