Can you add semple script for the same

Like create a temp table or table variable and insert your sample data into table and also always use sql quote for the...

What is this? What is your query and hint????

Thankx Jeff Sir, You made my job very easy with Quirky Update. Its a very nice artical.

Thankx once again for your great help as its giving me a lots of...

Dear Sir,

Please provide me a way to achieve this.

I have a table which have 4 field.

Field may be client id, asset code, amount field and date field

Sample data is given...

dear team kindly revert

the amount should be updated with previous amount present for client

I want output like mentioned in blelow code but dont want use co-related queris

drop table #series

create table #series

(

ids numeric(18,0) identity(1,1),

cln_id numeric(18,0),

ast_cls varchar(25),

val numeric(18,2),

val_dt datetime

)

insert into #series(cln_id,ast_cls,val,val_dt)

select * from...

and i need latest date data present client wise and asset wise

No its giving me wrong out put

as its giving me repeted data for client code 124 code AD

DECLARE @Table TABLE

(

code int,

ast_cls_cd varchar(25),

DateTimesDATETIME, ...

sorry jeson i query i want multiply not addition

No ReturnPercent its only name it have full numeric value like amount.

Of course i tryed from my side but not found any solution

;With RowOrder As

(

Select clnt_id, ret, blnd_bnmk_val, row_num As rn

From #eod_blnd_bnmk

)

,

CumReturnCTE As

(

Select r.clnt_id, r.ret, cast(r.blnd_bnmk_val as float) As...

Please its on urgent basic

thankx all for your responce

You Can use SQL Import/Export Wizard for transfer the SQL data into Access Database