SELECT Min(ScheduledShipDate) as ScheduledShipDate, Min(ReportShipDate) as ReportShipDate, Min(InvoiceDate) as InvoiceDate, Min(ReportShipOrInvoiceDate) as ReportShipOrInvoiceDate, CASE WHEN Min(ScheduledShipDate) = 0 THEN Min(InvoiceDate) ELSE Min(ScheduledShipDate) END as ShipInvoiceDate FROM #ERPDatabaseName#.OrderHeaders ordhd LEFT OUTER JOIN #ERPDatabaseName#.OrderLines lin ON lin.OrderHeaderID = ordhd.OrderHeaderID LEFT OUTER JOIN #ERPDatabaseName#.Items itm ON itm.ItemID = lin.Itemid WHERE 1=1 AND ordhd.ManufacturerID = AND ordhd.DistributorID = AND ordhd.#_dateField# = AND itm.ItemID =