Query some values from a XML datatype result…
SELECT [datumtijd] ,(CAST(body AS XML).query('declare namespace ns1="http://totietoot.nl/example/person/1/0"; declare namespace soapenv="http://schemas.xmlsoap.org/soap/envelope/"; declare default element namespace "http://totietoot.nl"; //soapenv:Envelope/soapenv:Body/ns1:Members/ns1:Person/ns1:ID' ).value('.', 'nvarchar(100)')) AS ID ,(CAST(body AS XML).query('declare namespace ns1="http://totietoot.nl/example/person/1/0"; declare namespace soapenv="http://schemas.xmlsoap.org/soap/envelope/"; declare default element namespace "http://totietoot.nl"; //soapenv:Envelope/soapenv:Body/ns1:Members/ns1:Person/ns1:Name' ).value('.', 'nvarchar(100)')) AS Name --,[body] FROM [DATABASE].[dbo].[Logtable] WHERE [kolom1] = 'waarde' ORDER BY datumtijd DESC