• 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/