August 30, 2008 05:20am pdt

1. angelIII 852,060
2. ee_rlee 458,453
3. capricorn1 353,096
4. chapmandew 340,052
5. mark_wills 327,230
6. aneeshatti... 189,721
7. matthews... 187,246
8. Thomasian 170,076
9. jinesh_ka... 167,181
10. sdstuber 147,877
11. jimhorn 129,200
12. peter57r 119,405
13. harfang 111,183
14. frankytee 108,644
15. DatabaseMX 105,997
16. hielo 94,350
17. TextReport 84,195
18. GRayL 82,934
19. boag2000 81,858
20. cactus_d... 77,446
21. ScottPletc... 77,436
22. dqmq 70,815
23. LSMCons... 66,900
24. mwvisa1 63,100
25. dtodd 62,424

1. angelIII 1,597,393
2. capricorn1 687,208
3. matthews... 477,157
4. ee_rlee 458,453
5. aneeshatti... 400,428
6. chapmandew 340,052
7. mark_wills 327,230
8. harfang 221,963
9. peter57r 219,434
10. imitchie 215,310
11. DatabaseMX 215,069
12. jimhorn 209,720
13. dqmq 194,080
14. GRayL 188,765
15. jinesh_ka... 183,470
16. sdstuber 180,375
17. Thomasian 170,076
18. frankytee 158,892
19. Lowfatsp... 148,233
20. mbizup 140,947
21. ScottPletc... 130,541
22. DanielWilson 120,378
23. MikeToole 118,033
24. appari 115,378
25. derekkromm 114,235

05.07.2008 at 10:53AM PDT, ID: 23383663

	[x] Attachment Details

SQL Help - Uniformity

Asked by Navicerts in SQL Query Syntax, MS SQL Server, SQL Server 2005

Hello,

I am trying to query for uniformity. I have a query that averages the weight of animals along with a counter and standard deviation. The final column I need to add is uniformity. I want this column to show the percentage of animals that fall within +/- 15% of the average. As an example if there were 10 animals and the average weight was 10 pounds and 1 animal weighed 8.4 pounds and one weighed 11.6 pounds (and the other 8 weighed 10 pounds) it would be a 80% uniformity.

Thank YouStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:

           
           
             Declare @farmname As NVarChar(50)
Declare @recorddate As DateTime
 
Set @farmname = 'xxxxxxx'
set @recorddate = '5/1/2008'
 
 
SELECT	
	[Farm],
	[House],
	RW.[Pen Number],	
	Convert(NVarChar, [Date], 101) As [Date],
	[Sex Code],
	Convert(Decimal(6,2), Avg((Convert(Decimal(6,3), [Weight])/10))) As [Weight],
	Count(*) As Counter,
	Convert(Decimal(6,2), StDev(Weight/10)) As SD
	--Convert(Decimal(6,2), Avg((Convert(Decimal(6,3), [Weight])/10)) * .85)
	--Convert(Decimal(6,2), Avg((Convert(Decimal(6,3), [Weight])/10)) * 1.15)
FROM 
	[Prod Random Weights] As RW 
INNER JOIN 
	Location As l 
ON 
	RW.[Location ID] = l.[Location ID] 
LEFT JOIN 
	[RDA Prod Pen Master] As pm 
ON 
	l.[Location ID] = pm.[Location ID] 
AND	pm.[Pen Number] = RW.[Pen Number]
WHERE 
	[Farm] = @farmname 
AND	DatePart(dd, [Date]) = DatePart(dd, @recorddate) 
AND	DatePart(mm, [Date]) = DatePart(mm, @recorddate) 
AND	DatePart(yy, [Date]) = DatePart(yy, @recorddate) 
GROUP BY 	
	[Farm],	
	[House],		
	RW.[Pen Number],
	Convert(NVarChar, [Date], 101),	[Sex Code]
ORDER BY
 	House,
 	RW.[Pen Number],
 	[Date]

           
         

Keywords: SQL Help - Uniformity

	Title
1	Questions about calculations dealing w…
2	How much does water weigh?
3	How to find the Standard Deviation in …
4	Logic for digital weigh scale?
5	Help with uniform hash distribution
6	Mean and Standard Deviation of an Ima…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

SQL Help - Uniformity

Asked by Navicerts in SQL Query Syntax, MS SQL Server, SQL Server 2005

About this solution