Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
select [Quote], [CustomerNumber], [Customer], [OrderReserveNumber], DateChanged, NewValue from MasterQuoteRec m inner join (SELECT QuoteID, max(DateChanged) AS DateChanged FROM History WHERE (Class = 'ProductionStatus' OR Class = 'AccountingStatus') GROUP BY QuoteID) hm on m.Quote = hm.QuoteID WHERE NewValue = 'In Shipping'
|How to run sql statements from SQLCMD or command line||2||33|
|SQL Select Query problems||10||36|
|How to upgrade the version of a SQL Server 2008R2 instance?||1||49|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!