Hai

Thanks for your Reply.

When i Check the compatibility level it was SQL Server 2000(80).

Still it was not attaching.

What i observed is when i attach data base in higher version...

Thanks for your reply.

When i check my error log.it was like this

1--The log scan number (673:392:1) passed to log scan in database 'master' is not valid. This error may indicate...

Thank u So Much Sir.

It works for me.

I am New to This forms.So I don't know how to Post.

Thank u so much for all your patient replies.

Thanks

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

...

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...

Thanks for your reply sir.

But it was not fulfill my request.

please check my attachment again sir.

i am waiting for your reply

Thanks