Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
SELECT dbo.Invoice_Detail.Packlist, dbo.Invoice_Detail.Customer_PO, dbo.Job.Customer, SUM(dbo.Invoice_Detail.Amount) AS invtotal, dbo.Invoice_Detail.[Document] FROM dbo.Invoice_Detail INNER JOIN dbo.Job ON dbo.Invoice_Detail.Job = dbo.Job.Job INNER JOIN dbo.Invoice_Header ON dbo.Invoice_Detail.[Document] = dbo.Invoice_Header.[Document] GROUP BY dbo.Invoice_Detail.[Document], dbo.Invoice_Detail.Packlist, dbo.Invoice_Detail.Customer_PO, dbo.Job.Customer, dbo.Invoice_Header.Document_Date HAVING (dbo.Invoice_Header.Document_Date = CONVERT(DATETIME, '2014-10-06 00:00:00', 102))
SELECT Packlist, Customer_PO, Amount, [Document] FROM [ppp].[dbo].[Invoice_Detail] where Document = '20866'
|How to script out data export||36||63|
|SQL Trigger or Function that updates table with old values||5||32|
|SQL Syntax: How to Find Commonality Among Similar Results||2||32|
|Help with stripping out character in SQL LEFT/RIGHT/REPLACE||2||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!