Appreciate it. Thank you!

Guys,

Both examples work great! Thank you very much for the quick response.

L

Guys,

I've just tested the logic below for @Begin_Period = 201701 and got "201700" for @Last_Period. I was expecting 201612 instead. Any suggestions? Thanks

DECLARE @Begin_Period int;
DECLARE...

Thanks Scott and Sg! That's what I was looking for. Des, I tried to use your solution before but came across the issue covered by the CASE statement Scott and...