Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO Alter PROCEDURE [dbo].[P_sp_EmailerProgram] -- Add the parameters for the stored procedure here @Email nvarchar(50), @IRBTurnCounter int AS /* SET NOCOUNT ON */ select top 1 Email, IRBTurnCounter from tbl_IRBMembors Order by IRBTurnCounter Desc UPDATE tbl_IRBMembors SET IRBTurnCounter = @IRBTurnCounter + 1, Email = @Email WHERE Email = @Email
Join the community of 500,000 technology professionals and ask your questions.