Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shrews14
Starting Member
37 Posts |
 Posted - 2008-07-09 : 10:27:04
|
| Hi i'm looking at producing a stats tool for my business, which not only produces a sum, population total(count), Min, Max, Avg, st Dev but also a median value and a 5%ile value and a 95 %ile value amongst other things.Can i create new aggregate function or do i have to work around?How can i achieve these?Thanks for you help chaps |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-07-09 : 10:54:21
|
| If you're using SQL 2005 look at RANK and NTILE functionsJim |
 |
|
|
|
|
|
Aggregate Stats