It sounds like you are after more of a calendar style output

[Code]

declare @yr as nvarchar(4)

declare @yrpre as nvarchar(4)

declare @wk as nvarchar(2)

declare @mt as varchar(2)

declare @lowerBound as datetime

declare @upperBound as...