Viewing 15 posts - 1 through 15 (of 66 total)
August 5, 2020 at 5:31 pm
Scott and Steve: thanks, there should have been a join, not sure why it was missed.
August 5, 2020 at 2:30 pm
Great, thank you John!
May 13, 2020 at 10:58 am
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?
December 5, 2019 at 7:58 pm
Great, works like a charm!
Thank you Jeffrey and Jeff.
IF EXISTS keeps returning an error (SS 2008 R2),
DROP SYNONYM sBewoners, does not.
Swapping the view Clients (I prefer to distinguish names used...
November 20, 2019 at 10:50 am
Working on it.
Learning all the time.
Thank you Jeffrey, and Jeff.
November 20, 2019 at 9:26 am
Thanks Scott. Will look into this.
November 19, 2019 at 4:21 pm
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...
November 19, 2019 at 4:20 pm
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...
November 19, 2019 at 12:41 pm
Okay, thank you.J.
January 24, 2018 at 9:57 am
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...
December 20, 2017 at 4:49 am
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...
December 18, 2017 at 4:47 am
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...
December 17, 2017 at 12:57 pm
My approach using the comments above:
With myCTE AS ( SELECT DISTINCT COUNT (*) OVER (PARTITION BY B.ZPTIDHUIS, B.ZPTIDAFD) AS CltAfd, ...
December 15, 2017 at 2:00 pm
@scott, @ZZartin: thank you for your suggestions. 🙂
December 14, 2017 at 12:27 pm