Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
Declare @OrdTranID int Set @OrdTranID = 9001 Select Left(p.afsSource,2) as busType, SubString(p.afsSource,4,4) as DealID, Sum(p.afsAMount) as afsAmount, st.cp as CompoundingMethod from proc_cfa.dbo.P_AvailableForSale p LEFT JOIN ( Select ps.DealID ,CASE WHEN COUNT(ps.PmtFrequency) > 1 THEN 'Split' ELSE MIN(ps.PmtFrequency) END cp ,MAX(ps.loanDate) LoanDate from proc_lt.dbo.P_PaymentStreams ps Group by ps.DealID ) st ON st.DealId = SubString(p.afsSource,4,4) where p.afsTransAction = @OrdTranID group by Left(p.afsSource,2), SubString(p.afsSource,4,4), st.cp
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.