Just checked in Profiler on which stage its stuck

A sp is made for that purpose. You can download it from

http://www.vyaskn.tripod.com/code.htm

Regards

Vijay

some sample data required for the fast result.

BCP is only used for bulk loading the database...

For other operation you need, link server connectivity. A simple wizard is available for creating the same.

For reference

http://msdn.microsoft.com/en-us/library/aa560998%28BTS.70%29.aspx

Or Use group by claue for your id

Vinay,

Add some sample data and expected result.

So it will help u help us

I Got the solution.....

Mentioned below

--===== Declare the working variables

DECLARE @clnt_id INT,

@tpl_id INT,

@ast_cls_cd VARCHAR(25),

@cumReturn NUMERIC(18,9)

--===== Calculate the portfolio using return multiply by previous available value for every row

...

Thankx Jeff Sir, For your replay,

how r u and how is your health???

Actually i got the solution of this problem but stuck again with this problem as a change...

I thought I am right, above mention is a feasible Solution.

Kindly provide the test script for batter result

I thought we can not use corelated query with in inner join..

Modified query.......using corelated join (But not recomended)

SELECT L.LogTableKey

,L.CreateDate

...

You simply use co-related join as sub query...

It may be help you...

SELECT L.LogTableKey

,L.CreateDate

,L.DictionaryTableKey

...

How can u connect server with out link server??:cool:

As you told you want to retrieve information from a centralize server, then centralize server should be connect to each and every...

I used below mentioned approch to solve this problem... Is this approch is right.

Output and solution attached for my both (Same Data And Actual Data) problem.

-- DROP TABLE #blnd_bnmk

CREATE TABLE...

Is there any additional information required for this query as provide actual data (attached) and sample data???

Any ideas or suggestions will be highly appreciated!