DougR_MS
asked on
Need to combine muliple rows of data into 1 NTEXT field in different table
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.
Thanks,
Doug
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.
Thanks,
Doug
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.