I hope that table has Primary Key.

If no, create it.

Than create dummy table referencing this table with FK. Truncate will not work then.

Find school hanbook on Math and read the chapter about interpolation.

Who knows...

At my age people cannot rely on their memory...

update L

set [values] = 0

from Lookup as L

left join source...

Did you manage to compare execution plans?

I see difference in 2 places:

1) second option uses implicit INNER JOIN, not CROSS JOIN as first one;

2) compare these:

(f.receivedate BETWEEN DATEADD(dd,-10,f.receiveDate) and f.receivedate)

and

g.receivedate BETWEEN DATEADD(dd,-10,f.receiveDate) and f.receivedate

You are using wrong name.

It must be master.dbo.xp_smtp_sendmail

And you need probably visit this site:

http://www.sqldev.net/xp/xpsmtp.htm

Always do

PRINT @strSQL 

just before

EXEC (@strSQL)

Do it and you'll see your error by yourself.

DECLARE @itemList VARCHAR(8000)

--SET

@itemList = ''

SELECT

@itemList = ISNULL(@itemList

Again, wrong database design returns problems.

Each entity must have a table. YOu don't have table for Invoices. Only for Invoice Rows.

You must create it.

Will you create it once as...

Also answered cople of times on this forum

You nned, probably, read what INTERSECT is for and than look for this functionality in BOL or ask here.

That's not only one you missed.

Compare this:

1) Create VIEW in all tarteted databases with set of fields matching set of inserted data;

2)...

Table inserted does not exist in the scope of dynamic SQL.

It must be mentioned only inside of trigger itself.

My approach does not touch design of the data storage db.

I add just a view with trigger - it's just SP with table parameter "inserted".

Table inserted exiats only in trigger.

To...