Even in CLR it is d*mned hard to do. I know, I've tried.

This is absolutely not true.

SQL, like Excel and some other high-level...

You would need an additional query to find the duplicate Primary Keys, or you will need a WHERE clause to pre-filter the duplicates out. If you can tell us...

You could use INSTEAD OF triggers on B, but I think that you will still have problems.

What you really need is a combined trigger from A & B, but of...

That depends on how you are inserting them. Can you show us the code?

Please let us know how it works out.

Actually, Sergy makes an execellent point, one that...

From you DDL code:

CREATE VIEW dbo.REV_KLIGEN_PATIENTEN

AS

SELECT

...

ISNULL (s.patientnummer, p.patientnummer) AS ZOEKPATIENTNUMMER, -- voorkeur-of synoniemnummer

...

FROMhl7_allePatientnummers s

LEFT JOIN dbo.hl7_patientenMetGesplitsteGebDat p

ONs.voorkeurspatientnummer = p.patientnummer

--

CREATE VIEW dbo.hl7_allePatientnummers

AS

SELECTsynoniempatientnummer AS...

What are the rowcounts of the two tables: [hl7_patienten], and [kop_synoniempatientnummers]?

Are you saying that they may not have SQL Server on the Web Server where the client code is executing, but you need to load the CSV file into a...

Milu (9/27/2008)

rbarryyoung

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

In SQL Server 2005, merely creating an identity column does NOT automatically create an index on that column. Therefore, in this case, your query is doing a "Table...

create proc bcp_test

as

begin

exec master..xp_cmdshell "bcp acs..bcpt in "C:\temp\Book1.csv -c -Upf -Ppf1 -Sdev"

end

Actually, the use of quotes does not look right here either. That command line should look more like...

I am not sure how accurate you intend this test to be, however, you should be aware the "CSV" stand...

An example of the Select command being issued would be helpful too.

Thanks,

There is no definition for the Table/View [hl7_allePatientnummers].