Hello comunity

First thanks for all of you for your replies.

I try this:

select substring('5695 - 0 | 7050-127 MONTEMOR O NOVO ...

Hello again

I find the solution with this:

WITH CTE

AS

(SELECT sl.ref, epcpond,

ROW_NUMBER() OVER(PARTITION BY sl.ref ORDER BY (ousrdata + ousrhora) DESC) as EndRec

FROM sl inner join planOref x on Rtrim(sl.ref) =...

Hello comunity

I found the solution, please visit this link:

http://akawn.com/blog/2012/01/query-and-update-an-excel-2010-spread-sheet-via-a-linked-server/

Very good post and explanation for all of you that use this tecnique like me.

Best regards

Luis Santos

Hello Lynn Pettis

Yes, you are right i forget my parameters (bostamp,ref,cor)

Thanks for your reply

Luis Santos

Sorry, i forget to mencioned that the compatibility level is :

SQL SERVER 2000 (80)

Maybe the problem is here ??

Thanks

Hello Lowell

Thanks for your reply that is very good, simply and clear.

Best regards,

Luis Santos

Hello again

After some test, the best performance script is the script send by Cadavre, with some adjustements:

UPDATE fi

SET fi.cor = 'Y', fi.tam = 'Z'

FROM (SELECT RTRIM(referencia) referencia

...

Hello comnunity

Any explication or advice regarding my last post.

Many thanks

Luis Santos

Hello Eugene

I will test your script for only for one REF(Article) = '2019023'. this article have only one invoice with one line.

Your script :

UPDATE fi

SET cor = 'Y', tam...

Hello Sean

Thanks for your reply, now you have give me a really good help about understanding my doughts, for this, many thanks.

I will go to try the second script that...

Hello Sean

Your reply don´t tell me anything useful about my doughts and also don´t suggest any kind of improvements.

But OK, if i could save 2 minutes :-Dthat´s fine for me.

Best...

Hello again

I test the statment with the WHILE from yeshupandit_2002 and i have adding a condition for ref like '2%', i talk about 8323 REF (article) with 315610 records on...

Thanks for all your replies

I will test the code that will run faster.

Best regards,

Luis Santos

Hello Carlos

Your Portuguese is OK, Carlos.

For everybody to answer me,i solve my problem after some changes on my original cursor and i test ir with 2 "referencia":

DECLARE cur1 CURSOR LOCAL...

Hello Chris

Thanks for your reply, for me is more readable to understand why the others suggestions works.

Best regards,

Luis Santos