Thanks man. we already has a partition. There are 96 columns in the Table A.No triggers are there.DataTypes are not fairly designed.All Statistics are update.Is Merge operator will be usefull?

Hi jeff and Bhuvanesh,

I was little bit busy for past few days.I found; u said not to use this query because it will raise issues when data is huge.I...

Hi Guys,

I solved the situation spend 1 whole day,Hope this may help u guys,

select A.ID,A.Invoice_Amount,a.Payment_Amount,A.CID,ISNULL(A.Payment_Amount -

(select SUM(B.Invoice_Amount)+A.Invoice_Amount

from TestDetails B

where B.ID < A.ID

and b.cid = A.cid

),A.Payment_Amount - A.Invoice_Amount)...

yes...what you said is correct.Please look the data,you will understand.

REgards

Varun R

Hi Vinayak,

You can use datepart function to acheive this.

SELECT CASE Datepart(mm, '2011-12-23 12:59:28.253')

WHEN 1 THEN 'january'

...

you can use Identity for your solution................!