Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
SELECT ii.itemNum, SUM(ii.Quantity) as quantity, SUM(ii.CostPer) as cost, SUM(ii.PricePer) as price FROM invoice_itemized ii LEFT OUTER JOIN Inventory i ON ii.ItemNum = i.ItemNum LEFT OUTER JOIN vendors v ON i.vendor_number = v.vendor_number LEFT OUTER JOIN Invoice_Totals it ON ii.invoice_number = it.invoice_number WHERE it.DateTime BETWEEN '09/01/2011' AND '09/30/2011' AND v.Vendor_Number = '8185021313' GROUP BY ii.ItemNum, ii.quantity, ii.CostPer, ii.PricePer
|convert this back to a date?||13||51|
|Query - which index being used?||2||25|
|SSRS Expression Null check - Whats wrong with my statement.||2||28|
|How to update "part of a text field" without changing the entire contents?||2||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!