A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Amazon AWS Windows with SQL Web For Business Application||3||32|
|how to extract last 6 digits from a varchar, sql||4||21|
|Specify timing interval fro change data||2||53|
|T-SQL: I need to add an index on a field||5||19|