Do you have any aggregate functions that you have implemented because the standard ones were not good enough?
Now it's time that we mention all T-SQL aggregate functions. The most commonly used are: COUNT – counts the number of elements in the group defined. SUM – calculates the sum of the given attribute/expression in the group defined.
An aggregate function is a mathematical computation involving a range of values that results in just a single value expressing the significance of the accumulated data it is derived from. Aggregate functions are often used to derive descriptive statistics.
An aggregate function can be used in a WHERE clause only if that clause is part of a subquery of a HAVING clause and the column name specified in the expression is a correlated reference to a group. If the expression includes more than one column name, each column name must be a correlated reference to the same group.
There are five aggregate functions, which are: MIN, MAX, COUNT, SUM, and AVG.
An aggregate function for SQL Server that produces a comma-separated list of values.
Title
-----------------
The Hobbit
The Two Towers --> The Hobbit, The Two Towers, Leaf by Niggle
Leaf by Niggle
Here's my implementation: A SQL CLR user-defined aggregate - notes on creating and debugging
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With