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 o.orderID, o.invoiceID, o.customerID, c.firstname + ' ' + c.lastname AS Name, o.invoiceDate, o.PayDate, o.ocr, o.orderDate, ISNULL(paymentStatusID, 0) AS paymentStatusID, o.paymentTypeID, orderStatusID, ISNULL(printed,0) AS printed, currencyID, paymentType, shipmentType, IsNull(sentOrder, 0) AS sentOrder FROM orders AS o INNER JOIN Customer AS c ON o.customerID = c.CustomerID INNER JOIN bklShipmentType AS bst ON bst.shipmentTypeID = o.shipmentTypeID INNER JOIN bklPaymentType AS bpt ON bpt.paymentTypeID = o.paymentTypeID WHERE (o.invoiceID > '0') AND (o.orgID = 11) AND orderSaved = 1 AND orderTypeID = 1 AND orderStatusID NOT IN (5, 8) AND o.paymentTypeID <> 12 ORDER BY orderDate DESC
|Solution for warm standby SQL server||20||34|
|VB6 ListBox Question||4||30|
|Sum Totals based on current date compared to fiscal year to get YTD totals||3||19|
|Whats wrong in the below query? Any help would be appreciated...||2||8|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!