I put it aside for several hours and came back with fresh eyes and found I had some bad logic elsewhere that was causing my erratic results.

Thanks everyone!

Roger

It doesn't return an error message when it runs... just doesn't evaluate correctly.

Lowell, this is perfect! Thank you so much!

Roger

Works perfectly! Thank you so much.

Rog

select dateadd(qq, datediff(qq, 0, getdate()), -1)

Nice!

If month(getdate()) = '01'

set @PaidThruRun = convert(datetime, ( '12/31/' + convert(varchar,year(Getdate()-1) )))

I'm only doing this for four quarters...

I actually got it to work by doing this:

If month(getdate()) = '04'

set @PaidThruRun = convert(datetime, ( '03/31/' + convert(varchar,year(Getdate()) )))

Perfect! Thank you!

Roger

Not sure what you mean. That if I don't have it looking at inserted and deleted and just update, that I can work around the issue?

Thank you.

Roger

Thanks... but there would be concurrent activity going on and it would be difficult to coordinate disabling the trigger whenever a certain process needs to be run (involved two different...

Thanks everyone for pointing me in the right direction. I did figure it out. I am setting it up to use in the body of an email where...

Thank you. What would the best command to shrink the database?

Looks like the data needs to cleared out from time to time.. it's tracking user action on the web.

This worked fine and ran quick... just had 5,000 records to update. Thank you everyone!

Roger

David Portas (7/28/2009)

---

I suggest you do this during a maintenance window while there is no-one using the DB. Emptying the file could take a long time, depending on the data...

I created the procedure and just try to run it and get the following message:

Server: Msg 17985, Level 16, State 1, Line 0

xp_sendmail: Procedure expects parameter @user, which was not...