Download GROUP_CONCAT string aggregate for SQL Server

Description

SQL Server CLR user-defined aggregates that collectively offer similar functionality to the MySQL GROUP_CONCAT function. Specialized functions ensure the best performance based on required functionality. Aggregates implemented using C#; requires .NET Framework 3.5.

Source Files

The download file groupconcat.zip has the following entries.


BuildProcessTemplates/DefaultTemplate.11.1.xaml
BuildProcessTemplates/LabDefaultTemplate.11.xaml
BuildProcessTemplates/UpgradeTemplate.xaml
Dev/SortingFeatures/GroupConcat.SortingFeatures.sln
Dev/SortingFeatures/GroupConcat.SortingFeatures.vssscc
Dev/SortingFeatures/GroupConcat/Compare/DecimalComparer.cs
Dev/SortingFeatures/GroupConcat/Compare/DecimalReverseComparer.cs
Dev/SortingFeatures/GroupConcat/Compare/ReverseComparer.cs
Dev/SortingFeatures/GroupConcat/GroupConcat.cs
Dev/SortingFeatures/GroupConcat/GroupConcat.publish.xml
Dev/SortingFeatures/GroupConcat/GroupConcat.sqlproj
Dev/SortingFeatures/GroupConcat/GroupConcat.sqlproj.vspscc
Dev/SortingFeatures/GroupConcat/GroupConcatDelimiter.cs
Dev/SortingFeatures/GroupConcat/GroupConcatDelimiterSorted.cs
Dev/SortingFeatures/GroupConcat/GroupConcatSorted.cs
Dev/SortingFeatures/GroupConcat/Installation Scripts/GroupConcatInstallation.sql
Dev/SortingFeatures/GroupConcat/Installation Scripts/GroupConcatUninstallation.sql
Dev/SortingFeatures/GroupConcat/Installation Scripts/Test.1.BuildTestData.sql
Dev/SortingFeatures/GroupConcat/Installation Scripts/Test.2.DemoFunctions.sql
Dev/SortingFeatures/GroupConcat/Performance Test Scripts/Performance.1.Setup.sql
Dev/SortingFeatures/GroupConcat/Performance Test Scripts/Performance.2.BuildCLRObjects.sql
Dev/SortingFeatures/GroupConcat/Performance Test Scripts/Performance.3.BuildTestData.sql
Dev/SortingFeatures/GroupConcat/Performance Test Scripts/Performance.4.RunPerformanceTests.sql
Dev/SortingFeatures/GroupConcat/Performance Test Scripts/Performance.5.ProcessPerformanceTestOutput.sql
Dev/SortingFeatures/GroupConcat/Performance Test Scripts/Performance.6.InterpretTestResults.sql
Dev/SortingFeatures/GroupConcat/Performance Test Scripts/Performance.7.Cleanup.sql
Dev/SortingFeatures/GroupConcat/PostDeployScript.sql
Dev/SortingFeatures/GroupConcat/PreDeployScript.sql
Dev/SortingFeatures/GroupConcat/Properties/AssemblyInfo.cs
Dev/SortingFeatures/GroupConcat/Test Scripts/Test.sql
Experimental/GroupConcatExperimental.sln
Experimental/GroupConcatExperimental.vssscc
Experimental/group_concat_dictionary/Creating Delimited Strings.sql
Experimental/group_concat_dictionary/PostDeployScript.sql
Experimental/group_concat_dictionary/PreDeployScript.sql
Experimental/group_concat_dictionary/Properties/AssemblyInfo.cs
Experimental/group_concat_dictionary/Test Scripts/Test.sql
Experimental/group_concat_dictionary/group_concat_dictionary.cs
Experimental/group_concat_dictionary/group_concat_dictionary.csproj
Experimental/group_concat_dictionary/group_concat_dictionary.csproj.vspscc
Experimental/group_concat_dictionary/group_concat_dictionary_delim.cs
Experimental/group_concat_dictionary/group_concat_dictionary_delim_sorted.cs
Experimental/group_concat_dictionary/group_concat_dictionary_sorted.cs
Experimental/group_concat_list/PostDeployScript.sql
Experimental/group_concat_list/PreDeployScript.sql
Experimental/group_concat_list/Properties/AssemblyInfo.cs
Experimental/group_concat_list/Test Scripts/Test.sql
Experimental/group_concat_list/group_concat_list.cs
Experimental/group_concat_list/group_concat_list.csproj
Experimental/group_concat_list/group_concat_list.csproj.vspscc
Experimental/group_concat_list/group_concat_list_delim.cs
Experimental/group_concat_list/group_concat_list_delim_sorted.cs
Experimental/group_concat_list/group_concat_list_sorted.cs
Experimental/group_concat_static/PostDeployScript.sql
Experimental/group_concat_static/PreDeployScript.sql
Experimental/group_concat_static/Properties/AssemblyInfo.cs
Experimental/group_concat_static/Test Scripts/Test.sql
Experimental/group_concat_static/ThreadSafeDictionary.cs
Experimental/group_concat_static/group_concat_delim_sorted_static.cs
Experimental/group_concat_static/group_concat_static.cs
Experimental/group_concat_static/group_concat_static.csproj
Experimental/group_concat_static/group_concat_static.csproj.vspscc
Experimental/group_concat_string/PostDeployScript.sql
Experimental/group_concat_string/PreDeployScript.sql
Experimental/group_concat_string/Properties/AssemblyInfo.cs
Experimental/group_concat_string/Test Scripts/Test.sql
Experimental/group_concat_string/group_concat_string.cs
Experimental/group_concat_string/group_concat_string.csproj
Experimental/group_concat_string/group_concat_string.csproj.vspscc
Experimental/group_concat_string/group_concat_string_delim.cs
Main/GroupConcat.sln//  w  w  w .j av a  2 s . c  o  m
Main/GroupConcat.vssscc
Main/GroupConcat/GROUP_CONCAT.cs
Main/GroupConcat/GROUP_CONCAT_D.cs
Main/GroupConcat/GROUP_CONCAT_DS.cs
Main/GroupConcat/GROUP_CONCAT_S.cs
Main/GroupConcat/GroupConcat.publish.xml
Main/GroupConcat/GroupConcat.sqlproj
Main/GroupConcat/GroupConcat.sqlproj.vspscc
Main/GroupConcat/Installation Scripts/GroupConcatInstallation.sql
Main/GroupConcat/Installation Scripts/GroupConcatUninstallation.sql
Main/GroupConcat/Installation Scripts/Test.1.BuildTestData.sql
Main/GroupConcat/Installation Scripts/Test.2.DemoFunctions.sql
Main/GroupConcat/Performance Test Scripts/Performance.1.Setup.sql
Main/GroupConcat/Performance Test Scripts/Performance.2.BuildCLRObjects.sql
Main/GroupConcat/Performance Test Scripts/Performance.3.BuildTestData.sql
Main/GroupConcat/Performance Test Scripts/Performance.4.RunPerformanceTests.sql
Main/GroupConcat/Performance Test Scripts/Performance.5.ProcessPerformanceTestOutput.sql
Main/GroupConcat/Performance Test Scripts/Performance.6.InterpretTestResults.sql
Main/GroupConcat/Performance Test Scripts/Performance.7.Cleanup.sql
Main/GroupConcat/PostDeployScript.sql
Main/GroupConcat/PreDeployScript.sql
Main/GroupConcat/Properties/AssemblyInfo.cs
Main/GroupConcat/ReverseComparer.cs
Main/GroupConcat/Test Scripts/Test.sql

Download

Click the following link to download groupconcat.zip.

groupconcat.zip




















Home »
  C# Free Code »
    Database »




ADODotNet
CSV
Database
EntityFramework
JSON
LINQ
LINQPad
Memcached
MongoDB
MySQL
NHibernate
Oracle
ORM
SQL
SQLite
SQLServer
SSIS