>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)?
DECLARE @testStr varchar(8000)
SELECT @testStr = Header + Value FROM .....
print @testStr
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.