Lynn, your suggested query runs in a second, as opposed to minutes for mine. THANK YOU!!! 😀 I just have one question: I thought because DateHired and...

The AttendanceDateTime field is of type datetime, as I said in my initial post. I haven't had a chance to try any of your suggestions out yet, having just...

Thanks - your syntax is better than mine, but that doesn't seem to make a difference.  I'm stumped and have rewritten all my code using an ASP DataList instead of...

Here's the first stored procedure (look for highlighting for where the problem variable gets created and then passed to the second stored procedure):

-----------------------------------------

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

ALTER          PROCEDURE...

What kind of information would you like?  I can send you the scripts, but not sure that's what you're looking for.  Please advise; I'm desperate!

Thanks!

Good idea!!  Thanks!