Forum Replies Created

Viewing 2 posts - 3,601 through 3,603 (of 3,603 total)

  • RE: Returning Values From Stored Procedures

    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...

  • RE: Using Xp_sendmail With the Recipients Generated From a Query

    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

    ...

Viewing 2 posts - 3,601 through 3,603 (of 3,603 total)