I want to select the complete last updated record and insert the concatenated info (header + value) into one field. I thing it's possible using a query like this... "select * from inserted for xml auto"... but my question is how can I store the result into a variable (string)?