1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
SELECT distinct dbo.CollatTrades.GroupID,
dbo.CollateralAgreements.CollatAgreementID CollatAgreementID,
(select Sum(Notional) from CollatTrades,IndexRates
where CollatTrades.CcyID + ' EUR' = IndexRates.IndexID
and IndexRates.RateDate = (select distinct convert(Char(24),UpdateTS,112) from Summitbb)
--and IndexRates.RateDate = '2007052'
and GroupID=dbo.CollatTrades.GroupID) MTLastAPDMCash,
dbo.CollatTrades.DateTransitStart DateLastAdpmCash
FROM dbo.CollatTrades INNER JOIN
dbo.CollateralAgreements ON dbo.CollatTrades.CollatAgreementID = dbo.CollateralAgreements.CollatAgreementID INNER JOIN
dbo.MasterAgreements ON dbo.CollateralAgreements.MasterAgreementID = dbo.MasterAgreements.MasterAgreementID
WHERE dbo.MasterAgreements.AgreementType in('REPOS IN FINE','REPOS SOM','REPOS')
and dbo.CollatTrades.ProductID <> 'Repo'
Group by dbo.CollateralAgreements.CollatAgreementID
having dbo.CollatTrades.GroupID = Max(dbo.CollatTrades.GroupID)
go |
Partager