Home Forums SQL Server 7,2000 T-SQL Need to put select and update in a single stored procedure RE: Need to put select and update in a single stored procedure

  • October 5, 2007 at 12:20 am

    #739400

    hi,

    thanks for your suggestion. Status should be updated to "close" only when mail is sent. Ok I will use 2 stored procedures, is it required to use transaction (client side)