Hey Marck

Got same problem over here. Already have a solution ?

thx

Jeff

JV

I'm a social assisant working as a ICT responsable for 5 years now. Working with SQL for 3 years. Responsable for everything that is IT minded : 5 servers, 25...

Or work the other way around ? Create a view and get external data in excel ?

Jeff

JV

I guess u can test this in the query analyzer of SQL 2000.

In the query tab u have an execution plan which shows the efforts.

Kind regards J

JV

i used this one to convert :

CAST(fld AS smalldatetime)

Regards

J

JV

i used this one to convert :

CAST(fld AS smalldatetime)

Regards

J

JV

i used this one to convert :

CAST(fld AS smalldatetime)

Regards

J

JV

Are all the databases on the same instance ? Which MDAC are u using ?

El Jefe

JV

Thx guys.

I've found a vba code that works fine.

Nevertheless thx !!!

J

JV

Brian

Thx for yr quick reply. I've created the profile as domain administrator. The sql server has also been started under this account.

JV

Hi

I've recently been setting up some replications. What version of SQL are you working with ?

When you are working with SQL 2000 you are automatically working with instances. Do you...

David

When I select * i see in that column April 2003, or May 2003, etc...

I can use year to substract the year, same for the month, except when i add...

Crispin

Here's the view I now have tried. The LIBPER is the column that contains the date like April 2003 :

SELECT TOP 100 PERCENT UPPER(LEFT(CODCEN, 5))...

Crispin,

thx fro quick reply. Date is like April 2003 or May 2002.

Kind regards

JV

I already have some more info. My instance has SQL_Latin1_General_CP1_CI_AI as collation, but my database hasSQL_Latin1_General_CP1_CI_AS as collation. It seems that SQL in the replication uses the instance collation in...