Hello expert.
There is a way to speed up the following stored procedure:
ALTER PROCEDURE [dbo].[UpdateSalesOrderDetailFields]
AS
BEGIN
UPDATE CurrentSalesOrderTemp
SET AD_Mode = vBM_BillOptionHeader.OptionDesc1
FROM CurrentSalesOrderTemp INNER JOIN
vSO_SalesOrderHistoryDetail ON CurrentSalesOrderTemp.SONo = vSO_SalesOrderHistoryDetail.SalesOrderNo INNER JOIN
vBM_BillOptionHeader ON vSO_SalesOrderHistoryDetail.BillOption2 = vBM_BillOptionHeader.BillOption
WHERE (vBM_BillOptionHeader.BillOptionCategory = '2')
UPDATE CurrentSalesOrderTemp
SET TempUnits = vBM_BillOptionHeader.OptionDesc1
FROM CurrentSalesOrderTemp INNER JOIN
vSO_SalesOrderHistoryDetail ON CurrentSalesOrderTemp.SONo = vSO_SalesOrderHistoryDetail.SalesOrderNo INNER JOIN
vBM_BillOptionHeader ON vSO_SalesOrderHistoryDetail.BillOption2 = vBM_BillOptionHeader.BillOption
WHERE (vBM_BillOptionHeader.BillOptionCategory = '1')
UPDATE CurrentSalesOrderTemp
SET FiberCableCode = vBM_BillOptionHeader.UDF_CODE
FROM CurrentSalesOrderTemp INNER JOIN
vSO_SalesOrderHistoryDetail ON CurrentSalesOrderTemp.SONo = vSO_SalesOrderHistoryDetail.SalesOrderNo INNER JOIN
vBM_BillOptionHeader ON vSO_SalesOrderHistoryDetail.BillOption2 = vBM_BillOptionHeader.BillOption
WHERE (vBM_BillOptionHeader.BillOptionCategory = '3')
UPDATE CurrentSalesOrderTemp
SET FiberCableDesc = vBM_BillOptionHeader.OptionDesc1
FROM CurrentSalesOrderTemp INNER JOIN
vSO_SalesOrderHistoryDetail ON CurrentSalesOrderTemp.SONo = vSO_SalesOrderHistoryDetail.SalesOrderNo INNER JOIN
vBM_BillOptionHeader ON vSO_SalesOrderHistoryDetail.BillOption3 = vBM_BillOptionHeader.BillOption
WHERE (vBM_BillOptionHeader.BillOptionCategory = '3')
UPDATE CurrentSalesOrderTemp
SET ESPGroup = vBM_BillOptionHeader.UDF_CODE
FROM CurrentSalesOrderTemp INNER JOIN
vSO_SalesOrderHistoryDetail ON CurrentSalesOrderTemp.SONo = vSO_SalesOrderHistoryDetail.SalesOrderNo INNER JOIN
vBM_BillOptionHeader ON vSO_SalesOrderHistoryDetail.BillOption8 = vBM_BillOptionHeader.BillOption
WHERE (vBM_BillOptionHeader.BillOptionCategory = '8')
END