select tsk.ownerId, tsk.ownerType, tsk.taskId, tsk.partnerId, tsk.partnerType, tsk.partnerContactId, tsk.dueDate, tsk.taskDescription, mem.email from tbl_WRK_Tasks tsk with (nolock) inner join tbl_FSPRO_Members mem with (nolock) on mem.ownerId = tsk.ownerId and mem.fsl_tablecode = tsk.ownerType and mem.fspro_userId = tsk.assignedTo where tsk.ownerId = and tsk.ownerType = and tsk.disposition = '?' and tsk.dueDate < dateAdd( day, 7, GetDate() ) and dateDiff( day, isNull( tsk.reminderSent, '1900-01-01' ), GetDate() ) <> 0 and tsk.dueDateNotification = 1
The below task is due on #dateformat( _dueDate, "mm/dd/yyyy" )# The below task is due tomorrow The below task is past due
Details
Task Name: #encodeForHTML( taskDescription )#
Task Status: OPEN
Task Due Date: #dateformat( _dueDate, "mm/dd/yyyy" )#
Click here to update task update tbl_WRK_Tasks set reminderSent = where ownerId = and ownerType = and taskId =

Task Reminders Sent

One Week Prior: #val( _oneWeekPriorCount )# reminders sent
One Day Prior: #val( _oneDayPriorCount )# reminders sent
After Due Date: #val( _afterDueDateCount )# reminders sent
 
Total Reminders Sent: #val( _totalRemindersCount )# reminders

No Task Reminders Sent