Hi Mike,

My son come up with simpler expression. :)

SELECT ((MonthNum + (12 - @fystart)) % 12 + 1) AS RealMonth ...

>>
>>Try

SET @RealMonth = (@MonthNum + @fystart - 1) % 12
>>CASE @RealMonth WHEN 0 THEN 12 ELSE RealMonth END
>>

>>
>Uhh... OK, but how do I include that within my TSQL select command...
>