Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
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.