There are books written on this subject, there is no real way for us to provide you with all the information you are requesting.

I would start by searching the Microsoft...

You get points not only for posting questions and answers on the forums but also for correctly answering the Question of the Day. You can see the top leaders...

The DELETE button was disabled after an incident in one of the threads where posts had been deleted.

Jan Van der Eecken (7/8/2009)

Lynn Pettis (7/8/2009)

Jan Van der Eecken (7/8/2009)

You guys just darn post too quickly, even if the likes of Barry and Steve are off on holiday, and...

Jan Van der Eecken (7/8/2009)

You guys just darn post too quickly, even if the likes of Barry and Steve are off on holiday, and Lynn has headed off throwing yellow...

Multiple post, please reply here.

Multiple post, please reply here.

Multiple post, please reply here.

Your code:

update invoices

set invoices.net = (select sum(trans.ipay)

from trans join invoices on trans.invno=invoices.invno

where invoices.invno = trans.invno)

What you want:

update invoices set

net = sum(t.ipay)

from

invoices i

...

Multiple post, please post replies here.

Multiple post, please post replies here.

Multiple post, please post replies here.

You will need to look at setting up a server side trace that is started using a startup stored procedure.

I'd start by researching SQL Trace and SQL Profiler in Books...

Is it looking up a value in the same row??

I also don't think the post count is working (incrementing) nor have I received any email notifications since the site went down.

Edit: Or I could be wrong on the post...