SELECT [inv_awbfk], [inv_cancelled], [inv_cusfk], [inv_cusnumber], [inv_date], [inv_goodsvalue], [inv_insurance], [inv_number], [inv_pieces], [inv_pk], [inv_printed], [inv_weight] ,cus_company ,cus_lastname ,cus_firstname ,cus_number ,cnt_code ,inv_total = (SELECT SUM(ivd_amount) FROM InvoiceDetails WHERE ivd_invfk = inv_pk) ,awb_number ,asatdate = @crt_date FROM [dbo].[Invoices] INNER JOIN Customers on inv_cusfk = cus_pk INNER JOIN AirWayBills on inv_awbfk = awb_pk INNER JOIN Countries ON cus_cntfk = cnt_pk WHERE inv_pk NOT IN (SELECT crt_invfk FROM CashReceipts INNER JOIN Deposits on crt_depfk = dep_pk WHERE dep_date <= @crt_date) ORDER BY inv_numberAny suggestions for speeding this up?