See, all I thought of was using a declare and setting it to a query, but with multiple results it never would have worked.

A subquery!  Thanks for showing...

Excellent, thank you!

I will try and provide this as soon as I am able.

My thought was that my syntax was simply incorrect.
I have no idea if this is...

Hah, that 's perfect!
Apparently I stared at it too long and lost sight simultaneously.

Thank you!

Correct, this is an integer, but I cannot seem to convert the datetime to an integer with a format of mm/dd/yy .

I get that, but that led me to change this one instance and when I set it for 9 days it worked like a charm.
I'm still unclear as to...

GROUP BY
You nailed it sir!

Something so simple and yet, I couldn't brain.
Thank you so much!!

Lynn, CASE nailed it, thank you!!

Luis, that is identical to what I just wrote up and works like a charm!

Thank you both!!