Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
"select t.opendate as 'OpenDate', t.Transact as 'Transaction', t.NetTotal as 'HeaderNet', isnull(sum(d.Quan*d.CostEach), 0) as 'DetailNet', t.FinalTotal as 'HeaderFinal', t.TenderTotal as 'HowPayAppTotal' " _ & "from dba.posDetail d, " _ & "(select h.opendate, h.Transact, h.NetTotal, h.FinalTotal, sum(p.Tender) TenderTotal " _ & "from dba.posHeader h, dba.howpayapproved p " _ & "where h.Transact = p.Transact and h.opendate between " & lbl_SrchStartDate.Text & " and " & lbl_SrchEndDate.Text & " group by h.opendate, h.Transact, h.NetTotal, h.FinalTotal) t " _ & "where t.Transact *= d.Transact " _ & "and d.prodtype not in (101) " _ & "and opendate between " & lbl_SrchStartDate.Text & " and " & lbl_SrchEndDate.Text & " " _ & "group by t.opendate, t.Transact, t.NetTotal, t.FinalTotal, t.TenderTotal " _ & "order by t.transact"
|export sql results to csv||6||40|
|Setting Macro in Access to Automate Running an Append at a Certain Time||2||28|
|Optimize the query||5||43|
|Current Month Filter in Visual Studio||10||23|