Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
SELECT A.ACCOUNT_ID, A.DESCRIPTION, A.TOTAL_BALANCE, A.DATA_CENTER, A.SALES_AMT, CASE WHEN A.ACCOUNT_ID = '10-200' AND A.DATA_CENTER = 'K00300' THEN (A.TOTAL_BALANCE - B.SALES_AMT) ELSE (A.TOTAL_BALANCE + A.SALES_AMT) END NEW_TOTAL FROM ACCOUNT_TEMP A LEFT OUTER JOIN ( SELECT A.ACCOUNT_ID, SUM(A.SALES_AMT) SALES_AMT FROM ACCOUNT_TEMP A GROUP BY A.ACCOUNT_ID ) B ON B.ACCOUNT_ID = A.ACCOUNT_ID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.