Yes, both versions are SQL Server 2008 Express

Sorry, a forgot to say: I'm using the line

SELECT CONVERT(CHAR(10),GETDATE(),110)

to get JUST THE DATE, without the time.

If there's another way to get just the date please, tell me...

Thanks!

It worked fine!

Yes, I agree with you...

I'm trying to convence (is this word correct?) this client to use original software... there is the Open Licence that offers good price and a easy...

That's reason I don't install Power Shell and NO ONE program there... he's...

About GSquared's query: the result has no line... nothing!

There's another detail: ANY name I use I get the error.....:hehe:

I know that it looks crazy but it's real 'cause I can't install Power Shell into my client 'cause he doesn't have original Windows and it doesn't validate the install...

Here...

Sorry, I forgot the final result:

SELECT A.NOME,

A.MATRICULA,

CASE P.TIPO_AULA

...

I did using the SQL Server.... I right-clicked 'View' and choosed 'New view'. There I've mounted visually my query and saw the result... now I understood!

Thanks everybody for helpning!

OK, let's go!

Table Alunos

/****** Object: Table [dbo].[ALUNOS] Script Date: 08/24/2009 15:46:34 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ALUNOS](

[CODIGO] [int] IDENTITY(1,1) NOT NULL,

[MATRICULA] [int] NOT NULL,

[NOME] [nvarchar](50)...

I found this connection string:

Driver={SQL Server Native Client 10.0};Server=SERVER\INSTANCE;Database=MY_DB;Uid=MY_ID;Pwd=MY_PWD;

It solved my problem but I still don´t know why the previous connection string didn´t work. Any idea?

Thanks for answer!

But I don´t wanna send a e-mail: I just need send a "event" that can be captured by Delphi. I have a toolbar on my program that changes...

Hi, thanks for helping!

This code will process each row using @RESULT from one line to another?

I need take the @RESULT from atual row and use it on the next row......

Thanks!!!

It works fine!

But, one more question: If cursors aren´t the best choice, is there another way to do this? I don´t wanna do this operation in a external software, I...