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.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Standard Error Calculations

Author  Topic  DaveM Starting Member 2 Posts Posted - 2004-11-30 : 17:35:27 I have stored procedure that I wrote that calculates the standard error of some statistical data. There are approximatley 1000 rows in the dataset and 50 replicate weights that need to be calculated in to the standard error value. The procedure that I wrote utilizes subqueries which, although accurate, is horribly inefficient. Does anyone have an example or article on how to calculate standard error based on such criteria? Or are there any SQL wizzards out there that are intersted in taking a peek at this to see if they can find a better way to acomplish what I am attempting. Thanks Dave