Value distribution | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Value distribution

Hi ! I have a database and I want to design a cube using analysis services. Is there a way to see the distribution of the values of a column ? I must create some intervals instead of using all the distinct values and the intervals must have almost the same number of samples. Thanks
I found a very useful stored procedure which does exactly what I want. If anyone is interested, the procedure can be found at the following address:,289483,sid87_gci1109458,00.html Thank you