reported as spam

Your problem is that you have not initialised your variables.

DECLARE @body2 NVARCHAR(MAX);

SET @body2 = @body2 + N'"Hello World"';

SELECT @body2; -- Returns...

Let's start with the CTE (Common Tbale Expression)
Because there is no guarantee that there are no gaps in the value of id in tbl_Client (even if it is an...

A small tweak to your code will get you what you are looking for

SELECT
  data.AcctNum
, data.EffDate
, data.InactiveDate
FROM...

In your ORDER BY, you need to 
replace ORDER BY CASE WHEN (tc.id %@rownumber) = 0 THEN 1 ELSE (tc.id %@rownumber) END
with ORDER BY CASE WHEN (tc.id...

Please do not cross post.
This post is a duplicate of https://www.sqlservercentral.com/Forums/FindPost1869698.aspx

CREATE TABLE #TestData (
SampleTime DATETIME
);

INSERT INTO #TestData ( SampleTime )
VALUES ( '2017-03-27 09:24:00.000' )
  , ( '2017-03-27 09:48:00.000' )
  , ( '2017-03-27...

Reported as spam

Your requirements for filtering the data are quite vague.
The code below will join the data, and return it all.  You can tweak the WHERE as needed.