Another tip for using WITH on MSSQL - prefix it with semicolon like this: ;WITH MSSQL makes it so that people pick up bad habits over the years and often you'l

Another tip for using WITH on MSSQL - prefix it with semicolon like this: ;WITH MSSQL makes it so that people pick up bad habits over the years and often you'll find missing semicolons at the end of statements. While the parser will intelligently handle missing semicolons for the majority of of scripts, it will bomb 100% of the time (at least up to 2008R2) on WITH.