We value your feedback.
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.
|Display Date and Time||7||48|
|Dynamically Construct and Execute a SQL Server Statements||10||50|
|SQL Query (lookup)||8||57|
|Question on sending emails using SQL Server 2008 R2 database mail||10||50|
Join the community of 500,000 technology professionals and ask your questions.