I used user defined function to accomplish this task..

Thank you all.:satisfied:

Thank you very much:)

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)