Hello Micky

The purpose for using a Cursor is because i need to run an Update not for one "referencia" = Article, but for more and less 170000, and for each...

Hello eugene

could you give me the sample on how to build the code ?

Many thanks

Luis Santos

Hello Lynn

i don´t understand your comment:

"you have to copy them to another query window and run them."

Do you refer to copy all the result into another TSQL windows ?

could...

Hello

Your TSQL return error RIGHT, i run like this

SELECT ASCII(RIGHT(CCT,20))

from cu

WHERE cct like '72.1.107%'

QA return : 55

I solve my problem using this UPDATE:

update cu

set cct = substring(cct,1,8)

from cu WHERE...

Hello again

you ask to me "inside a query". That was possible ?

Have you a simple example to see the result for example on Northwind database.

Best regards

Luis Santos

Hello

excellent, it was exactly what I needed.

Many thanks

Luis Santos

Hello Again

Many thanks for all yours suggestions and informations link.

Best regards

Luis Santos

Hello comunity

Yes, i comment deliberately out @RunningTotal in your FETCH...INTO, because the TSQL returning error

it´s also true that is EDEB > Zero then ECRED = 0 .

But, thats ok i´am...

Hello comunity

Don´t worry anymore about my problem , but i solve them.

best regards

Luis Santos

hello Jack

i will keep trying to explain:

You are going to have to do some translation for me. There is no CustomerID column in the information you provided. Can you translate...

Hello Jack

First, many thanks for your reply you probably solve my problem but i need to test it.

I have only one dought, suppose that i have 2, 3 or more...

Hello comunity

I write the code to create table ML and also the lines for 1 document. Also, if i help you , i think the problem is that the update...

Hello comunity

Nobody have an ideia to solve my problem ?

Luis Santos

Hello Sean

Have you find a solution or ideia for my problem ??

Thanks

Luis Santos

Hello Sean

Thanks for your reply.

I attach the script to create table ML and also to insert the records.

on my trigger when i write ,

IF (RTRIM(@SUBCONTA) = '' OR RTRIM(@SUBCONTA)...