public override void OnApplyTemplate()
        {
            Button myButton = this.Template.FindName("MyButton", this) as Button;
            myButton.Click +=new RoutedEventHandler(myButton_Click);
            myButton.Content = "Initialized";
        }

<Window x:Class="VerticalGridColumns.Window1"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:data="clr-namespace:VerticalGridColumns"   
    Title="Pivoted Grid" Height="300" Width="300">

    <Window.Resources>
        <ObjectDataProvider x:Key="PersonsProvider" ObjectType="{x:Type data:Persons}" />

        <ControlTemplate x:Key="HeaderButtonTemplate" TargetType="{x:Type Button}">
            <Border Width="auto" 
                    Height="auto" 
                    BorderThickness="1" 
                    BorderBrush="Gray" 
                    Padding="10,3,10,3"
                    Background="Gainsboro">
                <ContentPresenter  HorizontalAlignment="Center" 
                                   VerticalAlignment="Center" 
                                   RecognizesAccessKey="True"/>
            </Border>
        </ControlTemplate>
        
        <DataTemplate x:Key="MyDataTemplate">
            <Border BorderThickness="1" BorderBrush="Gray">
                <Grid ShowGridLines="True">
                    <Grid.RowDefinitions>
                        <RowDefinition Height="auto" SharedSizeGroup="NameRow" />
                        <RowDefinition Height="auto" SharedSizeGroup="AgeRow" />
                        <RowDefinition Height="auto" SharedSizeGroup="GenderRow" />
                    </Grid.RowDefinitions>
                    <TextBlock Grid.Row="0" VerticalAlignment="Center" Padding="3,0,3,0" Text="{Binding Path=Name}" />
                    <TextBlock Grid.Row="1" VerticalAlignment="Center" Padding="3,0,3,0" Text="{Binding Path=Age}" />
                    <TextBlock Grid.Row="2" VerticalAlignment="Center" Padding="3,0,3,0" Text="{Binding Path=Gender}" />
                </Grid>
            </Border>
        </DataTemplate>
        
        <ControlTemplate x:Key="MyListBoxTemplate">
            <Grid Grid.IsSharedSizeScope="True">
                <DockPanel>
                    <Border BorderThickness="1">
                        <Grid DockPanel.Dock="Left">
                            <Grid.RowDefinitions>
                                <RowDefinition Height="auto" SharedSizeGroup="NameRow" />
                                <RowDefinition Height="auto" SharedSizeGroup="AgeRow" />
                                <RowDefinition Height="auto" SharedSizeGroup="GenderRow" />
                            </Grid.RowDefinitions>
                            <Button Template="{StaticResource HeaderButtonTemplate}" Grid.Row="0">Name</Button>
                            <Button Template="{StaticResource HeaderButtonTemplate}" Grid.Row="1" Content="Age" />
                            <Button Template="{StaticResource HeaderButtonTemplate}" Grid.Row="2" Content="Gender"/>
                        </Grid>
                    </Border>
                    <VirtualizingStackPanel IsItemsHost="True" Orientation="Horizontal" />
                </DockPanel>
            </Grid>
        </ControlTemplate>
    </Window.Resources>

    <Grid>
        <StackPanel Margin="10,10,10,10">
            <TextBlock Text="This is an example of a pivoted grid" Margin="0,10, 0, 10" />
            <ListBox x:Name="MyListBox" Height="auto" 
                     ItemTemplate="{StaticResource MyDataTemplate}"
                     Template="{StaticResource MyListBoxTemplate}"
                     ItemsSource="{Binding Source={StaticResource PersonsProvider}}" 
                     VerticalAlignment="Top" />
        </StackPanel>
    </Grid>
</Window>

namespace WpfDemoControlLibrary
{
    public class Accordion : StackPanel
    {
        static Accordion()
        {
            DefaultStyleKeyProperty.OverrideMetadata(typeof(Accordion), 
                new FrameworkPropertyMetadata(typeof(Accordion)));
        }

        protected override void OnInitialized(EventArgs e)
        {
            base.OnInitialized(e);
            this.InitializeAccordion();
        }

        protected void InitializeAccordion()
        {
            Expander selectedExpander;
            foreach (UIElement element in this.Children)
            {
                selectedExpander = element as Expander;
                if (selectedExpander != null)
                {
                    selectedExpander.Expanded += new RoutedEventHandler(selectedExpander_Expanded);
                }
            }
        }

        void selectedExpander_Expanded(object sender, RoutedEventArgs e)
        {
            Expander selectedExpander = sender as Expander;
            Expander otherExpander = null;
            ContentPresenter contentPresenter = null;
            double totalExpanderHeight = 0;

            if (selectedExpander != null)
            {
                foreach (UIElement element in this.Children)
                {
                    otherExpander = element as Expander;
                    if (otherExpander != null & otherExpander != selectedExpander)
                    {
                        if (otherExpander.IsExpanded)
                        {
                            contentPresenter = otherExpander.Template.FindName("ExpandSite", otherExpander) as ContentPresenter;
                            if(contentPresenter != null) 
                                totalExpanderHeight -= contentPresenter.ActualHeight;
                        }
                        otherExpander.IsExpanded = false;
                        totalExpanderHeight += otherExpander.ActualHeight;
                    }
                }

                if (selectedExpander.IsExpanded)
                {
                    contentPresenter = selectedExpander.Template.FindName("ExpandSite", selectedExpander) as ContentPresenter;
                    if(contentPresenter != null) 
                        contentPresenter.Height = this.ActualHeight - totalExpanderHeight - selectedExpander.ActualHeight;
                }
            }
        }
    }
}

<Style TargetType="{x:Type local:Accordion}"></Style>

[assembly: XmlnsDefinition("http://schemas.rooijakkers.net/presentation", "WpfDemoControlLibrary")]

DECLARE @categories AS VARCHAR(1024)
      SELECT @categories = CASE IsNull(@categories,'')
                                    WHEN '' THEN CategoryName
                                    ELSE @categories + '; ' + CategoryName
                            END                               
      FROM Categories 
      ORDER BY CategoryName
SELECT @categories

DECLARE @categories AS VARCHAR(1024)
SELECT @categories = COALESCE(@categories + '; ', '') + CategoryName  
FROM Categories
ORDER BY CategoryName
SELECT @categories AS CategoryNames

DECLARE @categories AS VARCHAR(1024)
SELECT @categories = CAST
(
    (SELECT  CategoryName + '; ' AS [text()]
    FROM Categories
    FOR XML PATH(''))
AS VARCHAR(1024))
SELECT @categories

DECLARE @categories AS VARCHAR(1024)
SELECT @categories = CAST
(
    (SELECT CategoryName AS CAT    FROM Categories FOR XML RAW, ELEMENTS, TYPE).query
    (
        'for $CAT in (row/CAT) order by $CAT ascending return concat($CAT, "; ")'
    )AS VARCHAR(1024)
)
SELECT @categories