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 |
|
tc
Starting Member
11 Posts |
 Posted - 2005-07-19 : 16:50:39
|
| Can you get the standard deviation of multiple columns? I've looked everywhere but can't seem to find what I'm looking for. |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-07-19 : 18:00:12
|
| I assume you mean that you already know about the "STDEV" and "STDEVP" functions and want to know if you can use more than one expression. Statistically, that doesn't make sense to me. What does it mean to have a standard deviation for more than one column? If the multiple columns are logically related, I guess you can combine them into one column in a temp table and then use the STDEV function. |
 |
|
|
tc
Starting Member
11 Posts |
Posted - 2005-07-20 : 08:22:12
|
| Thanks for your reply. The columns are all related, and in reality, I think the table was designed wrong, but it is what it is. I can create the temp table but I just thought there might be a way use the stdev function with more than one column. Thanks again. |
|
|
|
|
|
|
stddev - multiple columns