spTransactions_DeleteSignup

            CREATE     procedure [dbo].[spTransactions_DeleteSignup](@iSignupID int)
as
BEGIN
    declare @ClientUsersID int 
    /* do not delete users that are internal/supervisor */
    set @ClientUsersID = (select UserID from SignupTransactions st, ClientUsers cu
        where st.UserID =  cu.ID
        and cu.InternalUser = 0 and isnull(cu.IsSupervisor,0)=0
        and st.SignupTransactionsID = @iSignUpID)

    BEGIN TRANSACTION
        UPDATE dbo.SignupTransactions
        SET IsDeleted=1, processed_date=getutcdate()
        WHERE SignupTransactionsID=@iSignupID

        if (@ClientUsersID > 0) 
        exec dbo.spDelete_ClientUsers @ClientUsersID, -1

        /*What should happen to the Fundraiser Solicitor Record???*/
    COMMIT TRANSACTION
END