Server: NPProdSQL
Username: DataFetcher
Password: Guest
Databases: NorthPointCore (core NorthPoint tables for the NorthPoint UI)
Databases: Analytics (Data warehouse)
SELECT * FROM client .tfPortfolioPerformancePivoted( @KnowledgeDate, @AsOfDate ) p
Example:
SELECT * FROM client .tfPortfolioPerformancePivoted( GetDate(), '2015-05-31') p
SELECT * FROM client .tfRiskData( GetDate(), '2015-04-30', '')
where PolicyVersion= 'ShortTerm' and PolicyType='Default' and RiskFactorModel IN ('Asset Class', 'Currency') option ( recompile)
How to connect to the NorthPoint SQL database
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.