<div>
Hi,<br />
<br />
Are you using SQL 2000?<br />
<br />
Can this be writtern as a user defined function?<br />
<br />
Regards<br />
&nbsp; David<br />

</div>


Hi,

Are you using SQL 2000?

Can this be writtern as a user defined function?

Regards
  David


<div>
Yes i am using sql 2000. A user defined function will do.
</div>


Yes i am using sql 2000. A user defined function will do.

<div>
todd, <br />
<br />
Thank you very much.
</div>


<div>
<div class="content wysiwyg-content">
HI <br />
<br />
I badly need a percentile function, it something like this <br />
<br />
&nbsp;getPercentile (value,set)<br />
<br />
I am hoping that there might be an extended stored <br />
procedure or something similar that we can use. <br />
<br />
Currently we do not have the option of using SQL 2000 <br />
Analysis Services. <br />
<br />
Any help is greatly appreciated.<br />
<br />
Thanks,<br />
syam
</div>
</div>


HI 

I badly need a percentile function, it something like this 

 getPercentile (value,set)

I am hoping that there might be an extended stored 
procedure or something similar that we can use. 

Currently we do not have the option of using SQL 2000 
Analysis Services. 

Any help is greatly appreciated.

Thanks,
syam

Percentile function

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.