spTransactions_RedownloadSignup

            CREATE PROCEDURE [dbo].[spTransactions_RedownloadSignup]
            (
            @UserID int
            )
            AS
            DECLARE @TransactionID int
            SET @TransactionID = (SELECT MAX(SignupTransactionsID) FROM SignupTransactions WHERE UserID = @UserID and processed_date is null and IsDeleted = 0)
            IF @TransactionID > 0
            UPDATE Transactions SET BeginDownload = null, EndDownload = null, DownloadUserID = 0
            WHERE TransactionID = @TransactionID and TransactionType = '{5F84002B-ABB1-4f50-A244-D4B14FBB1579}'