@drew: thank you Drew for taking the time to look at my code.
Changing table name 'Bewoners' to 'Bewoners_STAGING' solved my problem.
Cheers,
Julian

Ooops, how obvious.
Should be the staging table.

Thank you Jeff, have to look into that.
Cheers,
Julian

Thank you Luis!

Drew and Scott,
Thank you.
Cheers,
Julian

USE xxx;
GO
WITH MYCTE AS
(
SELECT  COUNT (*) OVER (PARTITION BY zzpclient_id) AS...

This is starting to look better!
Want to use as a storedprocedure with (optional) parameters for various reports.
IDHuis (location), IDAfd (department within location)
Any thoughts?

Thanks for your input and guidance...

Okay, in a bit of a panic here to come up with a soluton. :pinch:
Will study your answer more thoroughly.
Thanks,
J.

Final solution here: https://www.sqlservercentral.com/Forums/FindPost1894101.aspx

Thank you Jeff, great!
Cheers,
Julian

(https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-apply-basics/)

DECLARE @IDHUIS VARCHAR(4)
DECLARE @IDAFD VARCHAR(4)
DECLARE @JAAR INT
DECLARE @WEEKBEGIN INT
DECLARE @WEEKEND INT

I meant my other question, not "previous post".
As a backup I have been looking at your suggestion (Columns "DateBegin" and "DateEnd").
I will have a shot at...

Yes, 2008R2

Hi Jeff,

For each row in the Date table, eg. for IDClient 180, I want to return the corresponding HrsPlan to be found in the LookupTable.
So for January...

Drew, thank you!
Julian