We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.
Join the community of 500,000 technology professionals and ask your questions.