Link to home
Start Free TrialLog in
Avatar of DougR_MS
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
ASKER CERTIFIED SOLUTION
Avatar of Lowfatspread
Lowfatspread
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial