Regarding your initial question. The length of the @cmd variable may be too short to accept all the dynamic text you are trying to insert. In this case, it would...

Here is another option that could be used:

where isnull(Message,'') > ''

Here are two more options, one returning an integer value.

declare @date datetime

select @date = '01/01/2008'

select year(@date) * 100 + datepart(week,@date)

select convert(varchar,year(@date) * 100 + datepart(week,@date))