We can also use any no. of semicolon before WITH also -
;;;with CTE as (select * from LocationMaster)
select LocationName from CTE
So, semicolon doesnt make any effect that how many semicolons you used after any statement or as a prefix to WITH while writing a CTE expression...:-P
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/