-
Statistical function in T-SQL
In my current project I need to calculate mean, mode, median and percentiles (95th percentile, 99th percentile) of a given data set.In this article I’ve put together a summary of what I’ve discovered during my research.The following code snippets …
Toronto, Ontario, Canada
Eastern Time Zone
info@maximconsulting.ca
Month: August 2011
Archive
Categorise
- aggregation
- audit
- average
- backup
- baseline
- cell value overwrite
- certification
- compliance
- cube
- data driven subscriptions
- data export
- datetime
- de-normalize
- graph
- hierarchy
- local time
- MCSE
- MDX
- Microsoft
- parent-child
- recovery
- restore
- rounding
- script table data
- Small cell value suppression
- ssas
- ssrs
- statistical functions
- stipline
- UTC
