> I have two tables, one holding task details and the Id of the employee
> they are assigned to, and another table holding an XML representation of
> an email to send to the employee telling them they have one or more
> tasks assigned to them. For example:
>
> declare @tblEmail table
> (
> intEmployeeId int not null,
> xmlEmail XML
> )
>
> insert into @tblEmail
> select 1, ''
> insert into @tblEmail
> select 2, ''
>
> declare @tblTask table
> (
> intAssignedTo int, ...

> How can I perform an insert into the tag of the XML column
> containing details like:
>
>

Dear Employee 1, You have been assigned the following tasks:

> Task 1

> Task 2

> Task 3

> Task 4

>
> And
>

Dear Employee 2, You have been assigned the following tasks:

> Task 5

>
> Can anyone help?

> UPDATE e
> SET xmlEmail.modify('insert
{sql:column("t.txtTitle")}

> into (/email/body/p)[1]')

> I couldn't quite get your tags right ( I've used

instead of

> ) but hopefully the technique will work for you?