See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
SELECT paymentmethod, payerdesc, type, [date] = case when type = 'c' then dos else posted end, pfirst+' '+plast as patientname, LTRIM( case when type = 'a' then payerdesc when type = 'p' then payerdesc when type = 'c' then ISNULL(cpt, '') +' - '+ ISNULL(left(cptdesc,100),'') end ) as description, amount, 'Medical Oncology' as physicianid, coalesce(cg.encountercode, '') as practclaimid, case when type = 'c' then 0 else 1 end as priority, left(cptdesc,100) as cptdesc, cpt as cpt, (SELECT sum(amount) from txn where t.chargegroupid = txn.chargegroupid and t.accountid = txn.accountid) as balance, (SELECT min(dos) from txn where t.chargegroupid = txn.chargegroupid and t.accountid = txn.accountid and type = 'c') as firstdos FROM txn t LEFT JOIN chargegroup cg on t.chargegroupid = cg.id WHERE t.accountid = 9949388 AND (cg.status1 not in ('rt','hd','rp','fc') or cg.status1 is null) AND cg.id in ( SELECT chargegroupid from txn where accountid = 9949388 GROUP BY chargegroupid having max(txn.created) > DATEADD(DAY, -365, GETDATE()) ) AND reversedref is null
|MS SQL page split per second is high||19||63|
|SQL Authentication and Win NT Authentication Issues||20||38|
|SQL Server Determine if date is recurrance date||3||36|
|SQLServer 2008R2 Cannot use text, ntext, or image columns in the inserted and deleted tables.||6||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!