Well I had no idea that a trigger would fire even if nothing is inserted/updated...

I modified the trigger to verify that SOMETHING was inserted before proceeding and the...

Right?! That's what has me baffled... If I put a value in the where clause that actually returns a row, this update runs just fine. Its only...

I can sure try!

Thanks,

Chris

No, but thats a good thought... I'll try disabling the trigger and see what happens-

I'll let you know tomorrow when I'm back in the office-

Chris

Hello Stoutheart,

Since you may have multiple events in a given day, for a given user, you may want to look at this a bit differently..

I would query to get the...

Hey Alan,

That was my point.. I had an issue running an update statement, so I started eliminating rows to figure out what was causing my problem. Eventually I...