Stored Procedure Help 1

[pyttviper]

What i want to do is Update a field in a table with new information without deleting the old info.

i retrive a record set from a query and set variables for each selected field then pass through the RS and inserts those values into another table. i want to update a field in a second table with one of the values but not overwrite the information in that field but add to it. i think that i can do the appending in the SP then overwrite the field.
something like:

@updateNotes = @Notes + @Type --where @type is the appending info
--Then 
Update Asset SET Notes = @updateNotes Where identifier = @identifier

 

[jhall156]

How about
UPDATE Asset SET Note = RTRIM(Note) +
(SELECT <TheTypeInfoField> FROM <TheOtherTable>
WHERE <SomeCriteriaIsTrue>)
WHERE <IdentifierCriteriaIsTrue> JHall