Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
SELECT FULLORDERNO, SHIPDATE, ITEMNO, DESCRIPTION, ITEMQTYS, BIGSTATUS, FullName FROM WhoOrderedWhatItems WHERE (ITEMNO LIKE UPPER(@ItemNo) + '%') AND (BIGSTATUS IN (@BigStatus)) ORDER BY SHIPDATE DESC, FULLORDERNO DESC Here are the Statuses: 2 Announced to Ship on D At Drop Shipper 7 Auth. for Return Z Auto-Checked b Back Ord-Not Alcd B Backordered d CC Auth Declined a Continuity Header p Continuity Ready C Customer Canceled U Drop Shipped E Exchanged u Forced Drop Ship 8 Full Credit Issued J Gift Prod With Inv G Gift Product-No Inv W In The Warehouse N Item Canceled F Item Canceled M Misc. CC Credit L Multi-Rack P Not Picked 9 Partial Crdt. Issued 1 Partial Exchange 6 Partial Refused 4 Partial Return 5 Partial Undeliv O Point of Sale t Rdy to Pick-Not Alct Y Refused Return R Returned v Shipment Stopped V Shipment Stopped S Shipped Q To Be Canceled If OS H To Be Drop Shipped A To Be Drop Shipped T To Be Picked q To Cancel-Not Alcd c To be Qualified X Tracer Issued I Undeliverable Return K Warehouse Backorder NULL NULL