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 |
|
goligol
Posting Yak Master
128 Posts |
 Posted - 2011-05-04 : 11:43:30
|
| I have the flowing table:O D M C Val CV_Val01000US 001 1 $0000 11684 0.8 01000US 001 2 $0000 9539037 1.2 01000US 001 3 $0000 8335789 1.9 01000US 001 4 $0000 4955700 1.5 from the Coefficient of Variation (CV_Val) I want to calculate the variance for each Val and add it as a new entity fro each row beside to the CV_Val column. First I want to know how to add the new column and then if anybody know based of CV how I can compute the variance?Thank you |
|
|
|
|
|
how to add new column and new calculation