Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
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
|Can Unique column have more than one Null?||8||47|
|How to pass a parameter to limit the colums returned in Stored Procedure SQL 2016||2||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!