Thanks for your reply

I have just one question ,this script must be verify if the article reference exist in the others DB to know if they make an UPDATE or...

Hello again Noeld

I detect the problem, you have forget the "from" clause. I test with the following update statment and they work fine.

Many thanks for your interest.

Best regards

Luis Santos

update d...

Hello Noeld

Thanks for your reply, but when i run your TSQL they return errors :

Your TSQL:

update d set intid= data.rnumb

(SELECT ROW_NUMBER() OVER (ORDER BY rno,rdata ASC) AS rnumb , cm,...

Hello Sugesh

I test your reply an i put them in an update statment like this :

update po set intid=

(SELECT ROW_NUMBER() OVER (ORDER BY rno,rdata ASC) AS ROWID FROM po poo...

Hello

i try your example but the same return this following error

Must declare the scalar variable "@conta"

Well the purpose is that i want to replace fields ve21,ve31,ve41,ve51 and...

Hello Stef

Many thanks for your help, your code work very fine and also it´s very similar to VFP that i use on my Client/Server application to build code against SQL...

Hello Peter

Ok, your code work fine , but i must declare and fixed the value of the parameter, but what i want is when i click for running the query,...

Many thanks Karl

it´s work OK

Luis Santos

Thanks for your help

Karl , i need to know in TSQL how i call your function:

funDaysInMonth(31122005)

Hello Karl

I want to see on the QA grid What records i affect with this UPDATE without making the COMMIT TRANSACTION, in ACCESS after building in design view the query...

hello David

Thanks for your help, but with theses functions i don´t improve the result that i want in my example.

i write this TSQL, that was very near to i want,...

Thanks for your reply

but effectively me sample is not complicate but if i use a statment like the following :

select ft.nmdoc,ft.fno,(case when ft.pais=1 then 'NAC' else case when ft.pais=2 then ...

Hi Martin

I would like to thank you for your excellent code that you have send me. They work very well

Thanks

Luis Santos

Hi Martin

I would like to thank you for your excellent code that is work very well.

Many thanks

Luis Santos

Hi Rudy

Thanks for your help, maybe the problem is that have not "Show system databases and system objects" checked.

When i install the SQLServer this propertie is always checked...