Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SSRS Access Remotely||5||74|
|SSRS Dynamic Column Names - Last 8 Weeks||3||55|
|How to resolve SQL Server DB deadlock which makes my application hangs ?||6||58|
|Parsing this XML works but the other one doesn't||9||27|