Thanks. I will try to optimize the openquery selections in the SQL Views.

The primary SQL Stored Procedure is

insert into aaa_payroll_pay_summary_WRK --This table is always truncated prior to this insert

select...