The cursor code came with the software but was used for finding users for a different reason. I just changed it to look for the inactivity. I will give yours...

That is actually what I have been doing. I Just thought there would be a way to reference the other table so I didn't have to have such big expressions...

I am facing the same problem with one difference. I am storing a weeks worth of hour values in one table and the current weeks values in a different one....

Here is the function that I am calling. The error is just a box that says "Syntax Error or Access Violation"

CREATE FUNCTION [dbo].[ufn_WeekdaysBetween]

(@StartDate datetime, @EndDate Datetime)

RETURNS int

AS...

Sorry for the delay in getting back. Thought I had it worked out a different way.

Below you can see the screen shot of what I am trying to do...