Hello Rudy

I have verify through QA the tables SYSDATABASES,SYSDEVICES,SYSFILES and SYSFILES1.

All of them have exactly the same path of the original installation, simply in EM i can´t see them.

In an...

Hello

Someone could give my some help about installing or creating a new instance of MSDE 2000 on the same machine that has installed Microsoft Sql Server 2000 Std. Edition .

Many...

Thank you for your help

Luis Santos

Hello Vladan

I try  to your frst query and i join in the WHERE conditions (ft.ndoc=1 AND ft.fdata between '20040101' and '20041231') and also i need to put in the GROUP BY...

Hello Vladan

i test the code , and i think is run more quickly, but i need to put on the group by clause "FT.FTSTAMP".

Also, the query is not totally perfect...

Hello Alzdba

Thanks for your help, but it didn´t work well because the values return on fields:

ValorGestao:5109,02

Valor322 :40872.160000

the correct values for both is 2554.5100

Also with this modification on your code i...

Thanks yours suggestions i will try them.

For Kenneth Wilhelmsson who has asked me for more information, i wil send them:

I'm explain the structure of all the tables:

FT - is the header...

Hello

Replie for Antares686 as requested :

Yes , i had jobs to makes backups on every day of the week, but also this backups (.BAK) failed wehn i try to restore the database.

This is an...

Hello

We had trying your suggestion , but the problem is always the same because the MDF is corrupted.

The configuration of SQL SERVER is exactly equal of the original installation.

Also the...

Thanks for your reply, but the problem is on my MDF file (error 9004) because i have tried your suggestion without success.

In fact when we tried to re-attach the database it was not...

Thanks for yours replies

I discovered that the problem is not on my table fi because FISTAMP in this table has no duplicates.

The problem is when i have the same REF twice...

Thanks Jonathan, the query work ok

Luis Santos

Thanks for your help

in your question :

Are you sure that "ref" is the same on both invoice and the credit note

Yes , i´m sure that is why i make this...

[Many tahnks for your help

Luis santos]

Luis,

Win98 does not support named pipes. Win2000, XP or Server 2003 are the only Windows operating systems that do. If the problem is...