Query shows different values than it should
select distinct
K.NameShort
,D.Name as [DebtorName]
,C.ClientId
,C.SetId
,C.CaseId
,C.ClientCaseNumber
,sum(PDH.Capital) as [Capital]
,sum(PDH.InterestsU) as [InterestsU]
,count (DISTINCT DD.DocumentId) as [IloϾ]
,PH.AccountType
,sum(PDH.Overpayment) as [Overpayment]
,PROV.ProvisionValue
,PH.OpDate
,C.DateImported
,PTD.Label
,CDV.EndServiceDate
,DD.DocumentNumber
FROM CaseDetails as C
join DebtorDetails as D on C.CaseDetailsId = D.CaseDetailsId
join PaymentCaseHistory as PH on C.CaseDetailsId = PH.CaseDetailsId
join PaymentDocumentHistory as PDH on PH.PaymentId = PDH.PaymentCaseHistoryId
join ClientProvision as PROV on C.ProductId = PROV.ClientProductId
join Client as K on C.ClientId = K.ClientId
join CaseDetailsView as CDV on C.ClientCaseNumber = CDV.ClientCaseNumber
join DocumentDetails as DD on C.CaseDetailsId = DD.CaseDetailsId
join ClientProducts on C.ProductId = ClientProducts.ClientProductId
join ProductTypeDefinition as PTD on ClientProducts.DefinitionId =
PTD.DefinitionId
WHERE (PH.IsDeleted is NULL or PH.IsDeleted <> 'True') and C.ProductId =
PROV.ClientProductId and PH.OpType ='W' and C.ClientId = 9 and C.SetId = 2
and C.CaseId = 25 and PDH.DocumentId = DD.DocumentId and PDH.Capital > 0
GROUP by D.Name, C.ClientId, C.CaseId, C.SetId, C.ClientCaseNumber,
PH.AccountType, PH.OpDate, C.DateImported, PROV.ProvisionValue,
K.NameShort, PTD.Label, CDV.EndServiceDate, DD.DocumentNumber
ORDER by DD.DocumentNumber
Shows such results: http://oi42.tinypic.com/d63ch.jpg Should show such:
http://oi43.tinypic.com/16aa0cm.jpg
Have no idea why such situation happened..
No comments:
Post a Comment