If anyone is having difficulty understanding what I am trying to do let me know and I will try to clarify. 🙂

DECLARE @InitialStartDate date,
        @rptStartDate date,
        @rptEndDate date
Set @InitialStartDate = '11/1/2018'
Set @rptStartDate = CASE WHEN [TransactionCount] = 2 Then DATEADD(dd,-30, @InitialStartDate)
                         WHEN [TransactionCount]...