Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
select a.soptype as SOPType, a.sopnumbe as OrderNumber, a.docdate as DocumentDate, a.custnmbr as CustomerNumber, a.custname as CustomerName, a.locncode as Warehouse, a.pymtrmid as Terms, a.city as City, a.state as State, a.shipmthd as ShippingMethod, a.taxschid as TaxScheduleID, a.voidstts as VoidStatus, b.taxdtlid as TaxDetailID, b.txdtottx as TotalTax from (select soptype, sopnumbe, docdate, custnmbr, custname, locncode, pymtrmid, city, state, shipmthd, taxschid, voidstts from sop30200 ) A left join (select sopnumbe, lnitmseq, taxdtlid, txdtottx from sop10105) B on a.sopnumbe = b.sopnumbe where (MONTH(docdate)= MONTH(GetDate()) AND (YEAR(docdate)= YEAR(GetDate()))) and ((a.soptype = '3' or a.soptype = '4') and a.voidstts<>1) and b.lnitmseq='0' order by b.taxdtlid, a.docdate
|Response back from stored procedure||6||32|
|Excel to create SQL insert||7||28|
|SQL syntax, SEL FROM sys.messages WHERE sys.messages.text LIKE ' %NULL%'||4||9|
|Hiding Duplicate Column values to easily break out groups||4||16|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!