Gentlemen,

Thank you SO much for your replies and your ideas.

I did manage to get it to work fixing several bugs: Create Cursor, operator misqueue and two closely spelled variables...

I'm a newbie to SQL Server. So, I don't really understand what you mean by Set-based? 

However, I believe I need to process each cursor record sequentially because of a...

The cursor is actually ordered correctly. The problem is in the Fetching...it seems out of place. Here's the entire SP code:

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS OFF

GO

-- EXEC SmartReport_LeaveOfAbsence 489492, '5/1/2006',...