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 COUNT(o.orders_id) AS ordercount, (DATEDIFF(DAY, o.date_purchased, osh.orders_status_history_timestamp)) AS timetaken FROM orders O, dbo.tblPS_orders_status_history OSH WHERE o.orders_status = 4 AND o.paymentMethodID = 1 AND o.orders_statusID = OSH.orders_status_history_id AND DATEDIFF(DAY, o.date_purchased, GETDATE()) < 31 GROUP BY timetaken ORDER BY timetaken
Join the community of 500,000 technology professionals and ask your questions.