Post reply

Duplicates in Sub Query

  • September 13, 2014 at 7:01 am

    #296102

    Dear Experts,

    I have the piece of sql code here below that has left me puzzled as it keeps giving out duplicates. Could someone examine the structure and advice on how to resolve this.

    isnull((select distinct (SUM(a1.ActualDebit) - SUM(a1.ActualCredit) ) from #MainAccount a1

    LEFT OUTER JOIN

    #BudgetAccount bb ON aa.AccountID = bb.AccountID AND a1.PeriodStartdate = bb.PeriodStartDate and

    a1.DateMonth=bb.DateMonth and a1.Budget = bb.Budget WHERE a1.AccountID = aa.AccountID and

    a1.Refdate >= @FROMDATE and a1.Refdate <= @TODATE GROUP BY a1.group1, a1.Group2),0)

    As Actual_CurrentMonth,

  • September 13, 2014 at 7:57 am

    #1745251

    Moderator,

    Kindly close this post, I have replicated it elsewhere

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply