I have a table that stores multiple repsonse for the same action. The table also has an indentity column.
What I need to do is combine all the responses for a particular action into another table's ntext colum based on the unique action.
The problem I have is that the response field in both tables is ntext. I know I need to use UPDATETEXT with a cusor, but am hoping that there is some sample code out there...
So what I have would be one action, ActionId = 3 that has 3 reponses. I need to combine those 3 response and then write that back to the 2nd table.