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.
USE [Dev] --Run the Appraisal proc passing in a few required parameters Declare @ReportData varbinary(max) Exec dbo.pAppraisal @ReportData = @ReportData out, @Portfolios = '1234567', @Date = '2014-3-31', @IncludeUnsupervisedAssets = 1, @IncludeClosedPortfolios = 1 Select c.PortfolioBaseCode, c.ReportHeading1 , a.SecTypeCode, b.Symbol, b.FullName , a.MarketValue, vs.IsUnsupervised From dbo.fAppraisal(@ReportData) a join dbo.vSec b on a.SecurityID = b.SecurityID join dbo.vSecVariant vs on vs.SecurityID = a.SecurityID AND vs.IsShort = a.IsShortPosition AND vs.SecTypeCode = a.SecTypeCode join dbo.vPortBase c on a.PortfolioBaseID = c.PortfolioBaseID
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!