Merge many TEXT results into one TEXT field?

[MikeBronner]

Hey All!

I've been reading up on the UPDATETEXT functionality, and it seems like a step in the right direction, however: I am unable to find any examples that update text fields based on query results.

I'm looking for something like this:

UPDATE target_table SET target_field = source_table.source_field FROM source_table

I know that the syntax is probably more akin to the UPDATETEXT functionality, however, I don't yet know how to incorporate a multi-result select statement into it.

Any ideas?

Take Care,
Mike

 

[sweth]

You can update a table based on join condition of another table and isssue select queries also.
Update A
Set A.Field1 = B.Field1
From A
Join B on A.Field2= B.Field2
Where
....

Thanks and Regards
Siva

 

[MikeBronner]

Yes, but how to I append the multiple TEXT field resulting from the join condition (one-to-many) in the single TEXT field?

Take Care,
Mike

 

[sweth]

See this helps
DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(item)
FROM table
WHERE whatever criteria

UPDATETEXT table.item @ptrval NULL 0 'new text';

Reference

http://www.perlmonks.org/?node_id=578924

 

[MikeBronner]

Yes, thanks sweth. I have that part figured out.

How do I the one pointer with results from multiple records, though?

Take Care,
Mike

 

[MikeBronner]

The above should read: How do I update ...

Take Care,
Mike

 

[MikeBronner]

*bump*

This hasn't been tried before?

Take Care,
Mike