I'll have a look at that, quick glance this seems to be what i'm looking for.

Thanks Howard

Hi Srikant

SELECT x.col.value('RecordID[1]', 'INT') AS RecordID,

x.col.value('Quantity[1]', 'INT') AS Quantity

FROM @xml.nodes('//Record/Photos') x(col)

Will the above not just return me the recordid an quantity?

I would like to be able to insert the...

Thanks I'll give that a try.

Just had a quick look at Openquery thanks.

So is the following the correct syntax for using a UDF from linked server in where clause.

SELECT TOP (100) PERCENT TimeStamp, Field1

FROM...