Thanks it's working fine now!!

Strange thing was that the subquery returned one column...

Maybe someting to do with the execution plan?

But again thanks!

Regards,

Hans

Will do that!

Thanks!

Thanks all!

I'm going to read up on the (snapshot) replication of SQL Server.

Regards,

Heisa

Hi,

If I use the BCP tool and change the SQLDATETIME field to SQLCHAR, it works! The format of the datetime in the importfile is yyyymmdd.

BCP is not as strict...

Ok thx!

I'll try to find a solution or otherwise use your work-around.

Thx

Regards,

Heisa

Thx,

I've added a zip file with the files:

importfile.txt - contains a few records of the import;

tblaankomsten.sql - contains the table script;

vwaankomsten.sql - contains the script of the view on the...

oh,

That would explain the systax error 🙂

Then I have another question,

I wanted to use this statement:

SET DATEFORMAT ymd

GO

BULK INSERT vwAankomstenBulk FROM 'C:\bap\import\INKM.20081229' WITH (FIELDTERMINATOR = '";"',

FORMATFILE='C:\bap\import\aankomsten.fmt')

GO

But one column in...

Hi Gail,

Did you have a chance to look at the UDF?

I already altered the UDF to check for duplicate keys, so the (damn) thing works now....

But I was still wondering...

Hi,

Thx!

I've added the definition of the table tblaankomsten and a file with the inserts.

This is based on this selection recordset:

agaID agaActie ...

Hi,

I am creating a cursor to read these records one by one:

agaID agaActie levID ...

Ok didn't realize that...

Hi,

Here is the UDF,

It is a quite some text... But I don't see an option to attach a file in the post....

There are two table variables @ArtNrs1 and @ArtNrs2 on...

Thx...

I know that is also an option...

But that would mean an extra step, that would make the process slower...

or does the WITH IGNORE_DUP_KEY the same?

I am looking for the best...