CTE Example with Pivot operator

  • KeithDB

    SSC Enthusiast

    Points: 180

    Comments posted to this topic are about the item CTE Example with Pivot operator

  • Lynn Pettis

    SSC Guru

    Points: 442073

    My only complaint about your code is the semicolon preceding the WITH for your CTE.  When creating a CTE it is required that the PREVIOUS statement be terminated with a semicolon, not the CTE begin with a CTE.  It is obvious that people doing this leads others not familiar with writing CTEs to think that the semicolon is required before the WITH when declaring a CTE.

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply