Thanks a lot..

After posting, I made a script.. here´s it..

delete from mytable

insert into mytable (fieldame1, fieldame2, fieldame3, fieldame4) SELECT xlsfield1 as fieldname1, xlsfield2 as fieldname2, xlsfield3 as fieldname3, xlsfield4 as...

Is there any way to do this with T-SQL? I have to frequently update a table on my the database from an excel file, the problem is that all the...

Thanks a lot for your teaching reply.

Do we have in this forum the possibility of marking a reply as THE SOLUTION? as we have in universalthread.com?

If we can, let me...

Thanks a lot...

I'll give this a try.. and tell you later if it works. Thanks again.

yes.. it repeats..

Imagine something like an invoice.. where the invoice number repeats for each item..

I think i have to say that I solved the problem with a little of programming.. but still i would like to optimize it with full SQL sentences if possible...

here...

Sorry.. I don't understand your suggestion...

Could you be more specific?

Thanks...

I guess it's not neccesary..

I would delete C1..

delete from POL_COV_RATE_DTL_V

where

ROW_ACTIVE_STS_D = 9999999 and UNITCOVERAGE_ID in

( select B.UNITCOVERAGE_ID

from POL_UNITCOVERAGE B

where B.UNITCOMMON_ID

in

(select A.UNITCOMMON_ID

from POL_UNITCOMMON A

where A.POLICY_ID = 1 )

)

Nope..

What I'm looking for is:

rec_num     cod_con_A tot_con_A   cod_con_R tot_con_R  
----------- --------- ----------- --------- -----------
123         A10...