Hello

Maybe i don´t understand very well your question but i want the (inserted.u_subconta where inserted.u_mlstamp is equal to ml.mlstamp), and as each line has ml.mlstamp (index) different my field...

Hello Sachin and Asparna

the script of Sachin is quiet perfect , but the unique problem is the result :

my invoice number 4562

i dont need the last number "2" of the...

Many thanks

That´s work fine.

Best regards

Luis Santos

Hello comunity

I create a simple select statment whith a variable, for example:

declare @numcli int

set @numcli = 11

select name,adress from customers where customers.no = @numcli

In ACCESS, when i define a parameter...

Hello comunity

I solve this problem and for those person that have the same one would should install sql server 2008 not by the autorun option, but you must with right...

Hello Dan

The error state = 1, and this article dont give me an answer to solve my problem, because state 1 report to "contact your system administrator".

On SQL server 2005...

Hello Paul

My last post responds to their doubts regarding your last forward.

I´am sorry if i insist but i need this script on Monday and I want to make sure that...

Hello again Paul

i send to you in Word 2007, the script for creating my table ML where you can see PK, Constraints...etc.

when you said:

"Anyway, the critical point here is that...

Hello Paul

Thanks again for your kind reply. you are right when you said:

" there is no unique index, constraint, or primary key."

I build my script simplifying the data for testing,...

Hello Paul

Have you see my last post, sorry if i insist but i need to be sure my query is correct for what iám pretend.

Best regards

Luis Santos

Hello Paul

Thanks for your reply, i understand how sometimes is difficult to give an opinion about solving one problem without any data to test, also i build this script for...

Hello comunity

Nobody have suggestions?

Best regards

Luis Santos

Hello again

I solve the problem, because on a this Select :

'Plafond COSEC'=ISNULL((select top 1 evalor from u_histcyc (nolock) , cl (nolock) , cc (nolock)

where u_histcyc.clstamp=(cl.clstamp collate SQL_Latin1_General_Cp1250_CI_AS) and

cl.no=cc.no...

Hello again

Many thanks for your reply , i will test it and it´s seems the better way to make what i need.

Best regards

Luis Santos

Hello

Thanks for your reply.

I will ask you if in the comunity, i could have an example on how to configure DBMAIL.

Also, have you a very simple example of:

"You can...