Home Forums SQL Server 2008 SQL Server Newbies Really confused newbie - Perhaps a Temp Table query? RE: Really confused newbie - Perhaps a Temp Table query?

  • March 5, 2013 at 9:04 pm

    #1593750

    dwain.c (3/5/2013)

    Lynn Pettis (3/5/2013)

    You know Dwain, now if we could just get you to use the semicolon as a terminator instead of a begininator! 😛

    Lynn - I'm 100% with you on that but old habits die hard. I'm at least trying to do it now when I write an article. Making it an everyday practice is a real challenge.

    Coming from an old COBOL environment with periods at the end of statements, it wasn't too hard to put semicolons at the end of statements in SQL for me.

    I just think this looks really weird:

    ;WITH SomeCte as (

    select ...

    )

    MERGE

    ...;