Both ALZDBA and GilaMonster, thanks for youre help and time, i learned a lot these 2 days.

I can now go further with coding.

Happy coding............

Hello, many thnx!!

I know indeed that there may be rows with same "Boekdatum", "Omschrijving1" and "Naam" but that the rows are from a different account.

I think i'm gonna compare with...

I tested youre script. Now it adds 2 rows indeed. Do...

Hello GilaMonster,

Youre script is indeed correct, but this does affect 0 rows:

INSERT INTO Table2 (C1,C2,C3)

SELECT C1, C2, C3

FROM Table1

WHERE NOT EXISTS (SELECT 1 FROM Table2 WHERE Table1.C2 = Table2.C2 AND...

USE [aspnetdb]

GO

/****** Object: Table [dbo].[Bankgegevens_voorlopig] Script Date: 01/09/2011 22:58:39 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Bankgegevens_voorlopig](

[Rekening] [nvarchar](20) NULL,

[Munt] [nvarchar](10) NULL,

[Verwerkingsdatum] [date] NULL,

[DebetCredit] [nvarchar](50) NULL,

[Bedrag] [nvarchar](50) NULL,

[Tegenrekening]...

SELECT Rekening, Munt, Verwerkingsdatum, DebetCredit, Bedrag, Tegenrekening, Naam, Boekdatum,

Omschrijving1, Omschrijving2, Omschrijving3, Omschrijving4, Onbekend1, Onbekend2, Onbekend3, Code

FROM Bankgegevenstest

WHERE NOT EXISTS (SELECT 1 FROM Bankgegevens WHERE Bankgegevenstest.Bedrag = Bankgegevens.Bedrag AND Bankgegevenstest.Boekdatum=Bankgegevens.Boekdatum AND...

I mean, don't insert rows form TABLE1 into TABLE2 which allready exist in TABLE2.

With as exists I mean, the row allready has data with matching data in columns C2,C3.

The tables...

Hello ALZDBA,

Lets say I have these tables:

TABLE1

C1......C2......C3

R1 a........b.......c

R2 a........d.......e

R3 a........f........g

TABLE2

C1......C2......C3

R1 a........b.......c

R2 a........h.......i

Now i wanna...

Hello Gilamonster,

Youre right about 1 and *.

I believe the select-statement is correct. The WHERE clausule after the select statement determines wich rows get inserted.

My question is how to get the...

The SELECT statement returns the values i wan't to insert, that is not the problem.

I now understand indeed select 1, it is the same as select *, read it on...

Hello, i don't understand it completly.

This is what i have:

INSERT INTO Bankgegevens (Rekening, Munt, Verwerkingsdatum, DebetCredit, Bedrag, Tegenrekening, Naam, Boekdatum,

Omschrijving1,Omschrijving2,Omschrijving3,Omschrijving4,Onbekend1,Onbekend2,Onbekend3,Code)

SELECT BV.Rekening, BV.Munt, BV.Verwerkingsdatum, BV.DebetCredit, cast(BV.Bedrag AS money), BV.Tegenrekening, BV.Naam, BV.Boekdatum,

BV.Omschrijving1,...

Hello,

THNX for reply, i found solution in this:

INSERT INTO Bankgegevens (Rekening, Munt, Verwerkingsdatum, DebetCredit, Bedrag, Tegenrekening, Naam, Boekdatum,

Omschrijving1,Omschrijving2,Omschrijving3,Omschrijving4,Onbekend1,Onbekend2,Onbekend3,Code)

SELECT BV.Rekening, BV.Munt, BV.Verwerkingsdatum, BV.DebetCredit, cast(BV.Bedrag AS money), BV.Tegenrekening, BV.Naam, BV.Boekdatum,

BV.Omschrijving1, BV.Omschrijving2, BV.Omschrijving3,...

Many thnx !!!

It works now with basic authentication.

I don't now why it doesn't work with windows authentication.

Maybe it has something to do with windows xp? I don't now.

Now gonna look...

Again many thnx for youre reply.

I allready noticed that thread earlier.

But i don't understand why it doesn't work normally. I installed Report Services under default conditions (native install).

In the rsconfig...

Thnx for youre reply,

I wen't to configuration manager and made sure SSRS is running under Local System account.

I had to enter a password for an encryption file and saved the...