Sql Server Management Studio (SSMS) 2012, Pivot, surround snippet.

Pivot.snippet

<?xml version="1.0" encoding="utf-8" ?>
<CodeSnippets  xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
<_locDefinition xmlns="urn:locstudio">
    <_locDefault _loc="locNone" />
    <_locTag _loc="locData">Title</_locTag>
    <_locTag _loc="locData">Description</_locTag>
    <_locTag _loc="locData">Author</_locTag>
    <_locTag _loc="locData">ToolTip</_locTag>
   <_locTag _loc="locData">Default</_locTag>
</_locDefinition>
	<CodeSnippet Format="1.0.0">
		<Header>
			<Title>CTE</Title>
      <Shortcut></Shortcut>
			<Description>Code Snippet for CTE with a Pivot.</Description>
			<Author>Craig Buchanan</Author>
			<SnippetTypes>
        <SnippetType>SurroundsWith</SnippetType>
			</SnippetTypes>
		</Header>
		<Snippet>
			<Declarations>
        <Literal>
        	<ID>Alias</ID>
        	<ToolTip>CTE's alias</ToolTip>
        	<Default>Alias</Default>
        </Literal>
        <Literal>
          <ID>Measure</ID>
          <ToolTip>Field to be summarized</ToolTip>
          <Default>Measure</Default>
        </Literal>
        <Literal>
          <ID>Pivot</ID>
          <ToolTip>Field to be pivoted</ToolTip>
          <Default>Pivot</Default>
        </Literal>
        <Literal>
          <ID>Value</ID>
          <ToolTip>Column value</ToolTip>
          <Default>Value</Default>
        </Literal>
			</Declarations>
			<Code Language="SQL">
			<![CDATA[
$Alias$ AS (

  SELECT  *
  FROM    (

$selected$ $end$

  ) v

  PIVOT (
    MAX($Measure$)
    FOR $Pivot$ IN ([$Value$])
  ) p

)
			]]>
			</Code>
		</Snippet>
	</CodeSnippet>
</CodeSnippets>