>>I'd use CTE to make it mainteinable (SQL Server syntax only).
>
>I do not use it anywhere. I try to make the SQL as much compliant as possible with SQL ANSI.
OK, since we're using SQL Server here I take advantage of what it offers.
If it's not broken, fix it until it is.
My Blog 
