All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.
SELECT Distinct Q.DATEOFSALE, C.ZIP, C.STATE, C.CITY, C.ADDRESS, C.LNAME, Q.ID, C.FNAME, Q.TOTAL, C.[CURRENT], C.OVER30, C.OVER60, C.OVER90, C.LASTPAIDAMT, C.DATELASTPAID, Q.TXNUM, Q.[DESC], Q.ITEMPRICE, C.CKEY, C.Fullname, C.BeginningBALANCE, Q.STATEMENTDT, [current]+[Over30]+[Over60]+[Over90] AS CurrentBalance, C.ADDRESS2, Q.[TYPE], Q.ID FROM tblCustomers as C Left Join (SELECT S.STATEMENTDT, S.DATEOFSALE, S.HOH, D.ID, S.TOTAL, D.ITEMPRICE , S.[Type], S.TXNUM, D.[Desc] FROM tblTXsummary as S INNER JOIN tblTXdetail as D ON S.TXNUM = D.TXNUM Where S.STATEMENTDT Is Null AND S.[TYPE] in ('CHG','PAYMENT','ADJUSTMENT')) as Q ON C.CKEY = Q.HOH WHERE ([current]+[Over30]+[Over60]+[Over90])>= @Min AND C.HSACard = 'False' order by 1,2
|JSON Response and request in VB6 application||11||65|
|Barracuda Bsckup Server 690||6||51|
|SQL syntax, SEL FROM sys.messages WHERE sys.messages.text LIKE ' %NULL%'||4||12|
|VBA: Personal Macro Retain/Highlight/Remove values in a selected column||4||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!