Thanks.  That works.

That gets me almost there I think.  What if I wanted the results to return the actual date of the Monday of every week?

We use identity fields all the time and have never had a problem with them.  It is just a lot easier to let SQL take care of them.    We have...

The DocID field is an Identity field in the ac_dochead table and the system we are using places the DocID along with the blob into the ac_docdetail table once the...

Thanks Phil.  That made a lot of sense and it helped.  I think I may have simplified too much though.  I'm actually dealing with three tables and now that I...

Right now the agent is set up to use SQL Server authentication.  Should it be set up for NT authentication instead or do we just need to make sure the...

You are correct, I want to create the second select using Inserted and I've attempted that as well without much success.

Here you go.  Both of these work.  The minor changes were really just trying to figure out the company table because it is set up as a linked server.  (That's...

Thanks everyone.  Based on your input I was able to change the query so it was SQL compliant.  A couple minor changes on the queries Frank and Gary wrote and I was...