Adam, I’ve worked though the code a bit and made a few small changes. But I am still having issues. Here is the current situation.

With the following, if @PayFormulaCode =...

ALZDBA,

Good point. Once I get it working, I’ll do it.

Adam,

As I mentioned before, it looks like the problem is moving down the sproc and I believe it’s just about out....

Adam, I thought the best thing to do was to post the complete sproc. I hope that's OK. I have some notes inside the sproc. Any suggestions will...

I made the change to IS NULL.

Here is the message that I am now getting after another adjustment or two:

“Msg 156, Level 15, State 1, Procedure TimeSheet_Insert_TimesheetEntry, Line 351.

Incorrect...

Adam,

What you said makes sense. I am almost there. This is the original code with the added code noted.

IF @PayFormulaCode = 'TS' AND @Units = 0 OR @Units = NULL

BEGIN...