omschrijving: nvarchar

verkoopprijs: float

they mean:

omschrijving - Description

Verkoopprijs: - Price.

I'm still getting (2054 row(s) affected)

That should change to 0 after running once, I have no idea why it doesn't just do that

but whenever I change omschrijving or verkoopprijs it...

nearly perfect, runs like a charm! haha thanks :p

haha I tried to understand it but it completely fkedup my brain :p

aye, got it all working fine now, tested and well 🙂

Though, I still didn't get the insert script working :p

If I change WHERE to AND it gives me this..:

(408014 row(s) affected)

which with where is:

(2054 row(s) affected)

---------------------------------------------

Isn't this because it doesn't know what to do with AND so it affects...

-- De toegevoegde artikelen toevoegen aan de artikel table.

INSERT INTO artikelen AR

SET [toegevoegd]= getDate()

LEFT JOIN [Hofstede].[dbo].[sparepartsupdate]

WHERE [artikelen] not in [sparepartsupdate]

I can't get any further so basically I'm pretty stuck on...

yupp...

After an hour of trying everything I could possibly think of I came to the conclusion that I am unable to create anything with insert into:p

very nice, thanks alot! 😀

I've been struggling with this for a few hours...

Thanks for the help! really appreciated 😀

groetjes :p

Msg 4104, Level 16, State 1, Line 2

The multi-part identifier "Hofstede.dbo.sparepartsupdate.omschrijving" could not be bound.

Msg 4104, Level 16, State 1, Line 3

The multi-part identifier "Hofstede.dbo.sparepartsupdate.verkoopprijs" could not be bound.

.....

:p

okay so I rewrote the columns, as you said...

UPDATE artikelen

SET omschrijving = [Hofstede].[dbo].[sparepartsupdate].[omschrijving] ,

verkoopprijs = [Hofstede].[dbo].[sparepartsupdate].[verkoopprijs] ,

gewijzigd = getDate()

WHERE(PartNrFabrikant in(

SELECT ar.PartNrFabrikant, ar.omschrijving, ar.verkoopprijs

FROM...

I've tried that... keep getting this error:

Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".