Hi Adam,

Your query works, but that is not what I am tring to do!

I am trying to update a...

Thanks for the Article Roi. There is one more thing you forgot to mention. You can't write a correlated subquery on a table varable where as you can on a...

Hi Dan,

That worked. Thanks a lot. However we have another problem.

Here's our qury based on the query you sent.

/*

with...

Thanks a lot!

Small update. I found there is one way you can do it. By updating the

sysmail_account table in msdb.

So I take the records into a loop update the...