perireddy.arikatla (9/22/2013)

---

Thanks For your Valuable Reply Sir.

It works when i give tha Party_code in the where clause

i.e

SELECT party_code, sum(inst_amt) as total_insts,

(Select Sum(paid_amt) as total_paid

From party_payments

Where paid_date < '11/27/2012' and party_code='HA20076'

Group by party_code) as TotalPaid

FROM party_payments where party_code='HA20076'

GROUP BY party_code

When i Run the query without giving party_code in where clause

i.e

SELECT party_code, sum(inst_amt) as total_insts,

(Select Sum(paid_amt) as total_paid

From party_payments

Where paid_date < '11/27/2012'

Group by party_code) as TotalPaid

FROM party_payments

GROUP BY party_code

It was Giving Following Error

Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Warning: Null value is eliminated by an aggregate or other SET operation.

But My Requirement is Party Wise Total Inst_amt Value irrespective of Given Date and Total Paid< '11/27/2012' (i.e Given Date)

Can Any body Help me Please