Only problem in this update is, It take just previous date portfolio portfolio and current date return to retrieve current date portfolio.

I just need to update current date portfolio using...

Another and Small Set of Sample script is mention below

-- DROP TABLE #blnd_bnmk

CREATE TABLE #blnd_bnmk

(

clnt_id int,

ast_cls_cd varchar(25),

[Date] DATETIME,

[IndexValue] NUMERIC(18,2),

[Return] NUMERIC(18,4),

Portfolio NUMERIC(18,4),

IsFlow CHAR(1)

)

CREATE CLUSTERED INDEX IX_#blnd_bnmk ON...

expected result already present in attached excel.

But for your refrence mentioned below

ScripQtyRateAmountRatio

Media World Limited7/1/20091000351.3351300From #holding

Buy-Media World Limited7/24/2009100081.3262475581326.25269973.75From #hold

Buy-MediaWorks Limited7/24/20091000269.9737525269973.7581326.25From #hold

Thankx Wayan I had done the same thing.

Thankx Again

Means what exectly your query processed.

Paul White NZ (5/29/2010)

---

This version is more efficient:

SELECT This.ClientCode,

This.FlowDate,

This.TempletID,

...

Yas you are right

WHERE MIN(GETDATE()) = GETDATE()--So its a next day date from your minimum date

I Hope this what you wanted! If you want to a batter solution then try to post your...

Thankx all to provide me the way to achive some intresting things.

Thankx for your post,

I tried Quarily Update from My self and but i gets failed as I am not able to debug the problem.

Still I want to know thwt...

Its Giving me wromg output as You can see the current output in me previous post.

U are taking first flow amount and devide other flow amount with that amount but...

So Rule in Return Amont should be Next Amount / Previous Amount

I want to calculate account return for client wise, TempletID wise, AssetCode and flowdate wise

(

ClientCodeINT,

FlowDate DateTIME,

TempletID ...

ok Elutin

Thanx four your help

can any one give me best algorithm for the same, so i can go ahead with development.

If sample code provided then its save my time.

Thankx