Viewing 2 posts - 3,601 through 3,603 (of 3,603 total)
They say that lazy people take most pains!
I had seen a syntax for an INSERT statement that went something like:-
INSERT Tbl_X
EXECUTE Sp_Y
Where Sp_Y returns a recordset.
I was wondering if there...
August 2, 2001 at 6:54 am
#417388
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