• vinu512 (12/26/2012)


    This would do what you are looking for:

    Select p.Month, SUM(p.cramount) As Credit, SUM(q.dramount) As Debit From

    (

    Select b.voucherno, DATENAME(MM, a.dt) As Month, SUM(b.cramount) As cramount From voucher As a

    JOIN voucherCr As b ON a.voucherno = b.voucherno AND a.vouchertype = b.vouchertype

    Group By b.voucherno, DATENAME(MM, a.dt)

    ) As p

    JOIN

    (

    Select b.voucherno, DATENAME(MM, a.dt) As Month, SUM(b.dramount) As dramount From voucher As a

    RIGHT JOIN voucherDr As b ON a.voucherno = b.voucherno AND a.vouchertype = b.vouchertype

    Group By b.voucherno, DATENAME(MM, a.dt)

    ) As q ON p.voucherno = q.voucherno

    Group By p.Month

    Thanks Vinu. I got my mistake:-)

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter