Yes, thanks.

Scott and Steve: thanks, there should have been a join, not sure why it was missed.

Cheers,

J.

Great, thank you John!

J.

I have something working.

My next problem is "Cascade Delete" constraints on the tables related to  Bewoners_Staging_1 and Bewoners_Staging_2

Records in tables get deleted. How would I go about this problem?

A MERGE...

Great, works like a charm!

Thank you Jeffrey and Jeff.

FWIW:

IF EXISTS keeps returning an error (SS 2008 R2),

DROP SYNONYM sBewoners, does not.

Swapping the view Clients (I prefer to distinguish names used...

Interesting!

Working on it.

Learning all the time.

Thank you Jeffrey, and Jeff.

Thanks Scott. Will look into this.

J.

Yes, all was fine.

At present changing the structure of the database and moving Access (with their relationships and constraints) tables into the SS database. The renaming of the staging- and...

• This reply was modified 5 years, 1 month ago by  JJR333.

Hello Jeff,

I have decided to go down your route, because it gives more flexibility in my opinion, and to avoid problems with redefining the constraints.

Q: how do you "know" to...

Okay, thank you.
J.

All seems to be working now. Thanks all of you for your help!
On a virtual machine on my laptop the old procedure (TRUNCATE and INSERT) took about 26 milliseconds.
The...

Thanks for your patience Jeff. 
I am fairly new to SQL. Having trouble getting my head around some concepts regarding Views. I see now that they can be Updated (updates...

Thank you Jeff and Jason,
I will try Jeff's suggestion first.
Does the approach below mean that most code in the StoredProcedure needs to be 'dynamic'?
Which is some rework...

My approach using the comments above:

    With myCTE AS
     (
        SELECT    DISTINCT COUNT (*) OVER (PARTITION BY B.ZPTIDHUIS, B.ZPTIDAFD) AS CltAfd,
 ...

@scott, @ZZartin: thank you for your suggestions. 🙂