- script of the CREATE TABLE :

.[secprice](

[ssp_number] [int] NOT NULL,

[ssp_sexcode] [char](3) NOT NULL,

[ssp_date] [datetime] NOT NULL,

[ssp_date_c] [datetime] NOT NULL,

[ssp_date_m] [datetime] NOT NULL,

[ssp_user]...

Thanks for your answer.

sorry, READ : new rows are inserted every day instead of updated.

Hi,

here the order of execution :

1)-run file migrate_all.cmd that execute the command :

call CheckSQLVersion %1 %2 %3 %4 %5

@if %errorlevel% ==...

a big Thank you sunny.

it is what I need.

Thanks for the reply but it is not what I'm waiting.

Thanks for your quick reply.

I try to explain how finding link between the both tables.

there are 2 tables.

a current table testv ( live table ) and historical table testOH.

the link...

Thanks for the reply.

what I need to do is :

I have 2 tables.

the current table and one historical table.

I read the first table, populate a temporary table with the...

thanks for your answers.

We thought to change de field into our table by adding the right Collation but we need to be Case Sensitive as we use Uppercase and Lowercase characters in...

Sorry, the answer is not for AKM but for Lee Rivers

AKM,

what you could do is :

DECLARE @l_int_cpt INTEGER, @l_int_tot INTEGER,

CREATE TABLE  table1 (tid NUMERIC IDENTITY, .....)

SET @l_int_cpt = 1

select @l_int_tot = count(*) from table1

(obtain...

Shas3, you're right. there is that I am thinking. We need a blind login to have the right to connect to the database. But question now is : how can...

Andy thanks for your quick reply.

One question, when your mention : 'change your connection string to use NT authentication'

does it mean that the change is in SQL SERver security (...

Thanks for your help!

freewarefw