Thanks John. I didn't consider that and will give it a shot.

Thanks, Troe

Thanks I will look into some third party solutions.

I just figured it out. Thanks for looking.

It's doing what is supposed to do.

Thanks again!!

Thank you so much GSquared!! The procedure ran less than 1 second when previously it took over a minute to run.

Thanks for the suggestions. The purpose of this procedure is to reconcile expense account records in the General Ledger (gltrx_all/gltrxdet tables) against voucher payments (apvohdr table). The General Ledger consists...

I'm sorry about that. Here's a script with a test db, the tables, test data, and the procedure.

Thanks.

The definitions for the tables are attached.

Thank GSquared.

The query execution plan is attached.

Thanks for you help.

I was afraid that would be the case.

Thanks.

It's in full recovery mode.

I scheduled the maintenance plan for 8:00 pm. However, I deleted the maintenance plan yesterday and recreated it and it ran last night. The only problem I have now is...

Thanks Chris. That was a good article. Now I have another site to add to my favorites!!

Thanks Sean. I will make the adjustment.

CONVERT(VARCHAR(16), '')

The modifications made by Chris have increased the performance of the procedure tremendously. You guys were very helpful. By the way, are...

I've added the transaction and try-catch block. Let me know if this will suffice.

Thanks.

USE [ISPurchasing]

GO

/****** Object: StoredProcedure [dbo].[cust_CreateJournalEntrymod] Script Date: 08/19/2011 09:44:07 ******/

SET ANSI_NULLS ON

GO

SET...