Standard Deviation - SQL Server Forums

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 2005 Forums

Transact-SQL (2005)

Standard Deviation

Author

Topic

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-21 : 08:00:20

Hi

I have table like this



SELECT 
	D_Part_No
	D_PERIOD_1,
	D_PERIOD_2,
	D_PERIOD_3,
	D_PERIOD_4,
	D_PERIOD_5,
	D_PERIOD_6,
	D_PERIOD_7,
	D_PERIOD_8,
	D_PERIOD_9,
	D_PERIOD_10,
	D_PERIOD_11,
	D_PERIOD_12
FROM INV_DEMAND_DATA

I want to find out the Standard Deviation for each D_Part_No.

If i have done like this SELECT STDEV(col1+col2+col3...coln)FROM TABLE
I got zero.

how to do it ...pls help on this

-------------------------
R..

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-21 : 08:29:56

Hi

I done like this....correct me if iam in wrong

SELECT   D_Part_No,
		 STDEV(Val)AS STD_DEV
FROM
         (SELECT D_Part_No  ,
                 D_PERIOD_1 ,
                 D_PERIOD_2 ,
                 D_PERIOD_3 ,
                 D_PERIOD_4 ,
                 D_PERIOD_5 ,
                 D_PERIOD_6 ,
                 D_PERIOD_7 ,
                 D_PERIOD_8 ,
                 D_PERIOD_9 ,
                 D_PERIOD_10,
                 D_PERIOD_11,
                 D_PERIOD_12
         FROM    DBO.INV_DEMAND_DATA(NOLOCK)
         WHERE   D_User_Id = 2890541
         ) p UNPIVOT (Val FOR Period IN( 
							  D_PERIOD_1 ,
							  D_PERIOD_2 ,
							  D_PERIOD_3 ,
							  D_PERIOD_4 ,
							  D_PERIOD_5 ,
							  D_PERIOD_6 ,
							  D_PERIOD_7 ,
							  D_PERIOD_8 ,
							  D_PERIOD_9 ,
							  D_PERIOD_10,
							  D_PERIOD_11,
							  D_PERIOD_12 
										)
         )AS unpvt
GROUP BY D_Part_No

-------------------------
R..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources