I always use the following script and it works great. After the script finishes and the logfile is still bigger then you want, just run it again for a couple...

Here is another option you can use for the zero-padding for the week:

REPLICATE('0', 2-LEN(DATEPART( ww,  myDateCol))) + CAST(DATEPART( ww, myDateCol) AS varchar(2))

Within a stored procedure you can also store the results of the complex query in a temporary table (e.g. SELECT INTO #complextable) and then use the self-join on the temporary...