select * from qmd_stockedItems where 1 = 1 and Lastorderdate < ORDER BY #_SortBy# _dateCode: SELECT Max(ScheduledShipDate) as ScheduledShipDate, Max(ReportShipDate) as ReportShipDate, Max(InvoiceDate) as InvoiceDate, Max(ReportShipOrInvoiceDate) as ReportShipOrInvoiceDate, CASE WHEN Max(ScheduledShipDate) = 0 THEN Max(InvoiceDate) ELSE Max(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 itm.ItemID =