Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
;WITH CTE_VALUES AS ( SELECT T.ACCT_NO, T.Value, T.Indicator, CASE WHEN A.BranchR = 'Z0' THEN A.BranchD ELSE A.BranchR END AS Branch, B.BranchName, T.FileMonth, B.BranchName + T.FileMonth AS BranchMonth FROM ASSETS T LEFT JOIN ACCOUNTS A ON T.ACCT_NO = A.ACCT_NO AND A.RowId = (SELECT MAX(RowID) FROM BSACTD WHERE ACCT_NO = T.ACCT_NO AND (BRANCHR <> 'Z0' OR BRANCHD <> '')) LEFT JOIN BranchCodes B ON CASE WHEN A.BRANCHR = 'Z1' THEN A.BRANCHD ELSE A.BRANCHR END = B.BranchCode GROUP BY T.ACCT_NO, T.Value, T.IND, A.BRANCHR, A.BRANCHD, B.BranchName, T.FileMonth ) SELECT ACCT_NO, BranchName,Indicator, FileMonth, SUM(Value) OVER (PARTITION BY BranchMonth) FROM CTE_VALUES ORDER BY BranchName, FileMonth
|SSRS reports -- "The subscription encrypted content was removed."||63||82|
|SQL Query Syntax Error||9||33|
|MS-SQL 2008 Standard - define the security for internal data||4||44|
|Optimize/Performance Tune Production Databases||11||41|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!