Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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
|SSRS report parameters set after publishing to report manager||1||49|
|configure service broker on all databases||2||76|
|Can Unique column have more than one Null?||8||44|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!