Custom aggregate function (concat) in SQL Server

by

You cannot write custom aggregates outside of the CLR.

The only type of functions you can write in pure T-SQL are scalar and table valued functions.

Compare the pages for CREATE AGGREGATE, which only lists CLR style options, with CREATE FUNCTION, which shows T-SQL and CLR options.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Insert an image in a column of a table that already has 5 columns
  3. How to avoid the “divide by zero” error in SQL?
  4. SET versus SELECT when assigning variables?
  5. Querying data by joining two tables in two database on different servers
  6. sql query to return differences between two tables
  7. Real life example, when to use OUTER / CROSS APPLY in SQL
  8. How to print VARCHAR(MAX) using Print Statement?
  9. Convert Xml to Table SQL Server
  10. Concatenate values based on ID
  11. Splitting delimited values in a SQL column into multiple rows
  12. How to find current transaction level?
  13. How to connect to SQL Server from another computer?
  14. EXISTS vs JOIN and use of EXISTS clause
  15. Group DateTime into 5,15,30 and 60 minute intervals
  16. SQL comma-separated row with Group By clause
  17. Restrict an SQL Server connection to a specific IP address
  18. Average of multiple columns
  19. SQL . The SP or function should calculate the next date for friday
  20. Cumulative Total in MS Sql server [duplicate]
  21. How do I find the data directory for a SQL Server instance?
  22. Unpivot with column name
  23. How can I delete using INNER JOIN with SQL Server?
  24. PostgreSQL: running count of rows for a query ‘by minute’
  25. How to do pagination in SQL Server 2008
  26. Convert varchar to uniqueidentifier in SQL Server
  27. Compute percents from SUM() in the same SELECT sql query
  28. Paging SQL Server 2005 Results
  29. How to write UPDATE SQL with Table alias in SQL Server 2008?
  30. SQL Server 2008- Get table constraints

Leave a Comment