Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.ms-sqlserver | Notorious Rube Goldberg contraption | 19,505 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 17,788 of 19,505 |
| Plamen Ratchev to All |
| Re: Group By Median: Custom Aggregate Fu |
| 09 Apr 10 12:43:18 |
b3da7023 From: Plamen@SQLStudio.com You can create custom aggregate with CLR: http://msdn.microsoft.com/en-us/library/ms131057.aspx But if you are using SQL Server 2008 you can pass table-valued parameters to functions and stored procedures and calculate median that way. http://msdn.microsoft.com/en-us/library/bb510489.aspx -- Plamen Ratchev http://www.SQLStudio.com --- SoupGate-Win32 v1.05 * Origin: you cannot sedate... all the things you hate (1:229/2) |
(c) 1994, bbs@darkrealms.ca