Here is the same thing avoiding CURSORs.

Use Test

GO

Declare @MyRecipients nvarchar (255)

Declare @MyMessage nvarchar (255)

Set @MyRecipients=''

Set @MyMessage = ‘Your timesheet is overdue, please send it ASAP.'

WHILE @MyRecipients IS NOT NULL

...