Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.
|Find unused columns in a table||12||93|
|SQL Query that uses count(*) over, possible to use distinct?||18||77|
|Need quicker response from an Execption table||11||45|
|DMV Script to find how many times statistics are utilized||2||27|
Join the community of 500,000 technology professionals and ask your questions.