I want to remove the cursor and do a insert from the unions and keep the commit every 5,000 rows.

Sorry I should have know better.  Here it is.

 COMMIT TRANSACTION

 BEGIN TRANSACTION

 DECLARE @ls_patientid varchar(32), @ldt_fromdate smalldatetime, @ls_claimno varchar(42),

 @li_stayid integer, @ls_cpt4 char(5), @ls_gcn char(5), @ls_diagnosis1 char(6),

 @ls_diagnosis2 char(6), @ls_diagnosis3 char(6), @ls_diagnosis4 char(6),

 @ls_providerid...

Thanks, this did the trick!

Thanks for the information.  I will move the app from the file server to each users pc.  I need to improve my MSAccess and VB skills.  Previously I was developing web apps in...