You've been around long enough to know that's not the correct way to post data.

You said that this needs to be dynamic, but there is nothing about this...

Someone with over 700 visits is asking where to place a WHERE clause.  REALLY?!?!

WHERE where?

SELECT client, client_id, c.begin_dt, end_dt,
    DATEADD(DAY, -1, LEAD(begin_dt, 1, end_dt) OVER(ORDER BY begin_dt)) AS new_end_dt
FROM #clients c
WHERE NOT EXISTS
(
    SELECT *
    FROM #clients c2
    WHERE...

There were several issues that I wanted to point out here.

• It's a BAD IDEA to have columns named just "ID".  When you get more complex queries with multiple tables that have...

/*
    The correct way to set up sample data.
    1) Use a script like this.
    2) Create a temp table or declare a table variable.
    3)...

Please don't create multiple topics for the same question.

Post replies here.

Drew

Please provide sample data and expected results as outlined in first link in my signature.  The sample data should be provided as a script that creates (temp) tables or declares...