Viewing 3 posts - 616 through 3 (of 617 total)
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
...
July 16, 2001 at 4:51 am
#417084