spTransactions_DeleteProfileUpdate

          CREATE  procedure [dbo].[spTransactions_DeleteProfileUpdate](@iTransactionID int)
            as

            declare @EndDownload datetime
            declare @ID int

            select @EndDownload = EndDownload, @ID = ID 
            from dbo.Transactions
            where TransactionType = '{DCEAFCC7-0290-488e-A194-953DE66D6AAB}'
            and TransactionID = @iTransactionID

            if @EndDownload is null
                update dbo.Transactions
                set 
                EndDownload = GETUTCDATE()
                where
                ID = @ID

            update dbo.ProfileUpdateTransactions
            set
            IsDeleted = 1
            where
            ProfileUpdateTransactionsID=@iTransactionID