Thanks for your Reply sir.

But With the below Query what you suggested

SELECT party_code, sum(inst_amt) as total_insts, sum(paid_amt) as total_paid

FROM @table WHERE paid_date < '2012-11-27'

GROUP BY party_code

with this query we will get inst_amt total also<'2012-11-27'. but irrespective of paid_date i want total inst_amt as instTotal But PaidTotal must be <Given Date i.e('2012-11-27')

I Think I Explained This Time Clearly

Any Body Please Provide me Solution.

Thanks