Order By calculated percentage

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

General SQL Server Forums

New to SQL Server Programming

Order By calculated percentage

Author

Topic

Stevan2020
Starting Member

25 Posts

Posted - 2012-09-17 : 13:58:56

I have having difficulty dynamically ordering by a calculated percentage.

When I only include the 3 percenterage calcs (Pct1, Pct2, Pct3) in the Order By clause, it all works fine.

When I add any other otions (Excess1, Excess2 and Excess3) to the case statement, the order by Pct2 fails.



Declare @so varchar(20)
Set @so = 'Pct2'

SELECT FDC.FDC AS PFC, FDC.DistrictName, 
	CASE WHEN coalesce(Month1.Q24excess, 0) = 0 
			OR coalesce(Month1.Q24max, 0) = 0 
		THEN 0 
		ELSE 
			Month1.Q24excess / Month1.Q24max
	END AS Pct1, 
	CASE WHEN coalesce(Month2.Q24excess, 0) = 0 
			OR coalesce(Month2.Q24max, 0) = 0 
		THEN 0 
		ELSE 
			100 * Month2.Q24excess / Month2.Q24max
	END AS Pct2, 
	CASE WHEN coalesce(Month3.Q24excess, 0) = 0 
			OR coalesce(Month3.Q24max, 0) = 0 
		THEN 0 
		ELSE 
			Month3.Q24excess / Month3.Q24max
	END AS Pct3, 
	coalesce(Month1.StockOnHand, 0) AS SOH1, 
	coalesce(Month2.StockOnHand, 0) AS SOH2, 
	coalesce(Month3.StockOnHand, 0) AS SOH3, 
	coalesce(Month1.Q24max, 0) AS Qmax1, 
	coalesce(Month2.Q24max, 0) AS Qmax2, 
	coalesce(Month3.Q24max, 0) AS Qmax3,
	coalesce(Month1.Q24excess, 0) AS Excess1, 
	coalesce(Month2.Q24excess, 0) AS Excess2, 
	coalesce(Month3.Q24excess, 0) AS Excess3
FROM dbo.tbl_CS_ExcessUnitStock_Month AS EUS 
	LEFT JOIN tbl_FDC AS FDC ON EUS.PFC = FDC.FDC  
	LEFT JOIN ( SELECT EUS.PFC, EUS.CurrentMonth, EUS.CurrentYear, 
								sum(coalesce(EUS.StockOnHand, 0)) AS StockOnHand,
								sum(coalesce(EUS.Q24excess, 0)) AS Q24excess,
								sum(coalesce(EUS.Q24max, 0)) AS Q24max 
							FROM dbo.tbl_CS_ExcessUnitStock_Month AS EUS 
							WHERE CurrentMonth = 4 AND FY = 2012 
								AND EUS.FinTen IN (	SELECT FinTen 
																		FROM tbl_Offices
																		WHERE AreaID = 'J' )		
								AND EUS.StockOnHand > 5000
							GROUP BY EUS.PFC, EUS.CurrentMonth, EUS.CurrentYear
						) AS Month1 ON FDC.FDC = Month1.PFC 
	LEFT JOIN ( SELECT EUS.PFC, EUS.CurrentMonth, EUS.CurrentYear,   
								sum(coalesce(EUS.StockOnHand, 0)) AS StockOnHand,
								sum(coalesce(EUS.Q24excess, 0)) AS Q24excess,
								sum(coalesce(EUS.Q24max, 0)) AS Q24max 
							FROM dbo.tbl_CS_ExcessUnitStock_Month AS EUS 
							WHERE CurrentMonth = 4 + 1 AND FY = 2012 
								AND EUS.FinTen IN (	SELECT FinTen 
																		FROM tbl_Offices
																		WHERE AreaID = 'J' )		
								AND EUS.StockOnHand > 5000
							GROUP BY EUS.PFC, EUS.CurrentMonth, EUS.CurrentYear
						) AS Month2 ON FDC.FDC = Month2.PFC 
	LEFT JOIN ( SELECT EUS.PFC, EUS.CurrentMonth, EUS.CurrentYear, 
								sum(coalesce(EUS.StockOnHand, 0)) AS StockOnHand,
								sum(coalesce(EUS.Q24excess, 0)) AS Q24excess,
								sum(coalesce(EUS.Q24max, 0)) AS Q24max 
							FROM dbo.tbl_CS_ExcessUnitStock_Month AS EUS 
							WHERE CurrentMonth = 4 + 2 AND FY = 2012 
								AND EUS.FinTen IN (	SELECT FinTen 
																		FROM tbl_Offices
																		WHERE AreaID = 'J' )		
								AND EUS.StockOnHand > 5000
							GROUP BY EUS.PFC, EUS.CurrentMonth, EUS.CurrentYear
						) AS Month3 ON FDC.FDC = Month3.PFC 
WHERE 
	EUS.StockOnHand > 5000
	AND EUS.CurrentMonth NOT IN (10,11,12)
	AND EUS.FinTen IN (	SELECT FinTen 
											FROM tbl_Offices
											WHERE AreaID = 'J' )		
	AND FY = 2012
GROUP BY FDC.FDC, FDC.DistrictName,
	Month1.StockOnHand, Month2.StockOnHand, Month3.StockOnHand, 
	Month1.Q24max, Month2.Q24max, Month3.Q24max, 
	Month1.Q24excess, Month2.Q24excess, Month3.Q24excess 
ORDER BY
	CASE 
		WHEN @so = 'Pct1' THEN 
			CASE WHEN coalesce(Month1.Q24excess, 0) = 0 
					OR coalesce(Month1.Q24max, 0) = 0 
				THEN 0 
				ELSE 
					Month1.Q24excess / Month1.Q24max
			END 
		WHEN @so = 'Pct2' THEN 
			CASE WHEN coalesce(Month2.Q24excess, 0) = 0 
				OR coalesce(Month2.Q24max, 0) = 0 
			THEN 0 
			ELSE 
				Month2.Q24excess / Month2.Q24max
			END 
		WHEN @so = 'Pct3' THEN 
			CASE WHEN coalesce(Month3.Q24excess, 0) = 0 
					OR coalesce(Month3.Q24max, 0) = 0 
				THEN 0 
				ELSE 
					Month3.Q24excess / Month3.Q24max
			END 
		WHEN @so = 'Excess1' THEN 
			coalesce(Month1.Q24excess, 0)
		WHEN @so = 'Excess2' THEN 
			coalesce(Month2.Q24excess, 0)
		WHEN @so = 'Excess3' THEN 
			coalesce(Month3.Q24excess, 0)
	END

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-17 : 14:21:39

whats the error you're getting?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Stevan2020
Starting Member

25 Posts

Posted - 2012-09-17 : 16:32:13

I am not getting an error. The query just fails to "ORDER BY" PCt1, Pct2 or PCt3, when I have an Excess in the Order By clause.
If I comment out the last 6 lines, the percentage "ORDER BY" all work.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-17 : 16:36:39

can you explain with data sample how you think order by is not serving your required output

please give

1. sample data
2. o/p you get for so=Pct2
3. o/p you actually expect for so=Pct2

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Stevan2020
Starting Member

25 Posts

Posted - 2012-09-18 : 12:55:12

I have reduced the query to just the relevant fields and pared down the data set as much as I can to still show the issue.

I beleive that the issue is related to the data where Q24excess is zero, but I am unable to correct the CASE STATEMENT.

Query:



Declare @so varchar(20)
Set @so = 'Pct2'

SELECT EUS.PFC AS PFC, 
	CASE WHEN coalesce(Month2.Q24excess, 0) = 0 
			OR coalesce(Month2.Q24max, 0) = 0 
		THEN 0 
		ELSE 
			100 * Month2.Q24excess / Month2.Q24max
	END AS Pct2, 
	coalesce(Month2.Q24excess, 0) AS Excess2 
FROM dbo.EUS AS EUS 
	LEFT JOIN ( SELECT EUS.PFC, 
								sum(coalesce(EUS.Q24excess, 0)) AS Q24excess,
								sum(coalesce(EUS.Q24max, 0)) AS Q24max 
							FROM dbo.EUS AS EUS 
							GROUP BY EUS.PFC 
						) AS Month2 ON EUS.PFC = Month2.PFC 
GROUP BY EUS.PFC, 
	Month2.Q24max, 
	Month2.Q24excess 
ORDER BY
	CASE 
		WHEN @so = 'Pct2' THEN 
			CASE WHEN coalesce(Month2.Q24excess, 0) = 0 
				OR coalesce(Month2.Q24max, 0) = 0 
			THEN 0 
			ELSE 
				Month2.Q24excess / Month2.Q24max
			END 
		WHEN @so = 'Excess2' THEN 
			coalesce(Month2.Q24excess, 0)
		ELSE EUS.PFC 
	END

Incorrect results as shown with "Excess2" in the order by clause. Order By Pct2

PFC Pct2 Excess2
460 0.344297 12223.74
481 0.029885 595.99
530 0.046459 2368.05
604 0.831603 26162.73
493 1.056076 48720.89

Correct results without "Excess2" in the order by clause. Order By Pct2

PFC Pct2 Excess2
481 0.029885 595.99
530 0.046459 2368.05
460 0.344297 12223.74
604 0.831603 26162.73
493 1.056076 48720.89

Data set:



CREATE TABLE [dbo].[EUS](
	[PFC] [smallint] NULL,
	[Q24Max] [decimal](12, 2) NULL,
	[Q24excess] [decimal](11, 2) NULL
) ON [PRIMARY]


Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,2957.28,1.88)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,3524.04,193.89)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,3823.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,4545.68,287.14)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,4926.64,214.85)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,5073.75,332.97)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,5236.34,159.17)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,5338.02,162.44)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,5347.38,498.11)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,5495.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,5541.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,5585.61,298.16)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,5586.6,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,5589.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,5653.4,331.46)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,5663.45,465.84)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,5686.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,5699.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,5840.15,274.41)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,5956.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,5971.38,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,5972.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6044.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6044.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6087.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6099.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6150.55,315.17)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,6195.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6242.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6247.55,72.59)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6247.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,6250.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6266.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6290.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6291.63,127.73)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6335.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6338.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,6421.87,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6426.05,61.67)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6429.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6449.62,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6456.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6463.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6486.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6494.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6501.92,3023.35)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6524.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6593.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6603.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6620.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6622.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6627.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6636.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6678.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6693.85,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6738.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,6758.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6762.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6769.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,6777.5,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,6778.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,6780.85,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6802.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,6813.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6816.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6834.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6841.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6853.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6860.54,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,6873.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,6887.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6888.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6891.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6904.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6907.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,6916.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,6922.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6923.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,6945.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7019.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,7024.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7062.05,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7065.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7066.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7075.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7083.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7086.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7103.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,7138.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7164.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7170.24,479.89)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7219.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,7225.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7241.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,7241.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7287.62,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7294.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7319.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7343.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7370.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7372.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7375.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7408.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7410.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7412.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7422.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7446.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7467.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7489.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7493.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7503.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7517.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7530.21,661.07)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7535.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7548.97,1510.82)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7549.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7574.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7590.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7621.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7639.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7647.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7656.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7657.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7659.87,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7668.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7683.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7685.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,7722.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7727.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7731.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7748.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7753.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7759.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7760.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7765.54,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7784.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7795.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7799.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7850.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7854.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7863.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7888.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7891.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,7894.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7901.87,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7906.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7910.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7938.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,7941.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,7953.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,7977.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7981.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,7991.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8000.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8001.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8058.34,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8073.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8074.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8083.54,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8085.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8109.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8111.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8135.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8143.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8167.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8171.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8171.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8172.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8181.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8185.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8193.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8205.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8218.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8220.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8234.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8244.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8245.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8267.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8290.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8328.19,157.66)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8329.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8334.67,202.36)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8342.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8355.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8356.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8362.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8382.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8388.34,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8391.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8404.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8417.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8458.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8459.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8463.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8464.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8471.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8486.75,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8489,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8495.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8503.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8506.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8529.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8531.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8534,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8544.52,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8547.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8567.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8568.38,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8592.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8612.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8619.62,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8637.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8654.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8662.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8668.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8677.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8694.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8707.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8715.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8716.86,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8721.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8724.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8736.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8743.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8746.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8753.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8771.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8772.52,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8775.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8781.86,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8811.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8814.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8823.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8829.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8833.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8833.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,8840.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8862.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8882.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8884.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8885.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8896.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,8904.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8940.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8982.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,8995.79,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,8998.43,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,8998.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9011.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9025.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,9028.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9060.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9090.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9092.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9103.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9113.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9113.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9119.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9132.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9139.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9143.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9148.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9148.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9155.43,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9177.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9180.34,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9188.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9188.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,9189.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9192.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9196.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9201.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9210.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9230.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9234.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9254.31,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9260.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9267.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9273.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9316.85,222.19)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9317.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9344.62,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9358.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9364.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9368.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9373.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9384.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9390.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9410.93,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9415.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9425.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9448.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9460.93,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9478.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9481.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9486.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9523.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9541.31,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9541.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9547.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9580.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9600.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9614.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9621.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,9647.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9675.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9676,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9676.87,137.92)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9686.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9705.05,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9706.2,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9711.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9727.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,9756.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9756.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9762.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9779.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9784.2,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,9788.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9801.86,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9810.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9826.85,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,9857.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9860.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9882.5,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9887.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9887.79,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9902.64,9098.18)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,9936.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9940.08,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,9969.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,9972.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,9978.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10000.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10006.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,10021.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,10024.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10033.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10057.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10070.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10099.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10107.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10139.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10146.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10154.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10184.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10206.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10213.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,10224.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,10232.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,10237.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10239.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10246.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10249.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10265.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10268.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10287.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10309.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10318.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10324.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10328.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10330.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10367.43,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10375.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10378.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10383.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10393.5,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10394.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10395.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,10400.6,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10406,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10409.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,10425.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10426,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10478.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10485.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10489.86,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,10492.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10494.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10498.93,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10538.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10540.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10541.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,10542.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10585.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10587.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10612.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10627.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10640.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10652.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10677.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10682.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10733.06,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10763.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,10780.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10785.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10819.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10823.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,10827.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10865.5,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,10880.93,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10903.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10906.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10917.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10925.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10927.52,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10935.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,10939.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10984.85,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,10985.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,10991.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,10993.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,11015,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11047.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11056.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11066.87,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11071.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11080.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,11192.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11227.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11233.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11246.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11258.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,11268.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11274.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11274.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,11282.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11300.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11300.9,1193.18)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11317.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11317.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11332.38,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11347.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11353.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11374.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11376.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,11378.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11409.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,11411.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11416.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11418.86,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11426.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11485.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,11499.43,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11515.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11530.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11546.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11559.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11567.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,11576.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11583.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,11589.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11614.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,11619.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11632.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11648.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11675.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11706.22,434.08)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11712.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11781.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11817.31,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11844.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11849.75,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11877.46,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,11885.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11893.31,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,11910.46,1731.27)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11974.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,11975.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,11992.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12017.3,1076.82)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,12040.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12041.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12054.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12056.19,2413.17)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12058.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12071.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12073.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12073.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12076.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12095.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12115.46,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12201.77,613.77)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12212.46,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12215.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12221.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12229.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12257.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12269.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12292.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12295.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12309.06,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12412.31,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12432.08,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12453.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12454.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12458.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12464.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12479.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,12538.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,12553.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12567.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12568.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12629.54,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12649.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12669.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12678.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12682.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12685.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12708.06,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12721.97,1195.26)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12731.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12744.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12758.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12798.6,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12828.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,12848.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12858.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12859.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,12868.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12869.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,12872.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12904.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12916.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,12955.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,12965.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12974.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,12981.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,12998.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13007.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,13022.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13024.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,13026.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13027.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13033.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13034.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13055.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13119.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13129.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13130.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,13166.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13180.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,13180.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13242.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,13245.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13268.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,13271.62,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,13295.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13300.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,13304.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13306.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13335.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13353.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13372.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13376.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13416.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13418.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13424.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13438.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13442.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13479.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13485.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13493.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13495.09,373.75)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13496.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13500.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13524.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,13587.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13590.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13601.16,918.11)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13602.34,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13630.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13646.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13660.34,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13672.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13707.38,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,13768.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13781.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13795.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,13816.64,23.14)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,13817.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13819.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13823.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,13832.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,13853.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13857.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13878.75,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13880.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,13927.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,13972.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,13984.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,13990.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14018.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14026.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14042.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,14047.46,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14055.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14060.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,14067.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14082.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14082.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14092.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14098.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14127.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14128.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14138.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14140.2,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14186.43,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14199.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14212.31,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14212.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14228,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14228.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14232.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14237.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14249.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14252.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14279.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14298.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14360.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14360.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14398.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14399.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14404.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14448.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14448.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14449.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14454.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14472.58,143.79)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14496.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14507.43,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14517.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14523.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14556.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14563.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,14568.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14570.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14575.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14577.75,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14587.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14598.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14670.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14685.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14697.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14699.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14712.2,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,14735.38,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14743.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,14745.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14758.79,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14765.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14782.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14783.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,14783.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14804.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,14836.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14951.93,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14969.05,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14982.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,14983.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,14984.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15054.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,15097.86,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,15109.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15117.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15119.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15125.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15153.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15163.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,15170.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15192.5,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15201.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15225.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15238.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15261.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15286.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15306.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15312.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15314.5,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15329.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15362.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,15376.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15465.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15480.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,15503.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15538.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15542.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15570.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15572.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15580.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15592.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15605.85,3411.12)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15618.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15637.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15639.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15642.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,15657.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15692.87,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15730.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15761.38,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15833.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15869.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,15909.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15948.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,15961.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,15964.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15978.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,15981.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16057.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16084.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16088.88,1442.3)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16100.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,16101.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16210.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16234.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16234.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16254.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16261.87,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,16268.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,16324.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,16351.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16399.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16412.88,595.99)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16417.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16425.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,16469.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,16471.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16494.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16567.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16577.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16579.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16586.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16591.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16604.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16616.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16639.92,8147.86)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16642.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16665.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,16685.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16688.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16697.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,16782.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,16792.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,16859.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,16887.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16894.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,16935.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16948.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,16949.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16955.95,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,16964.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,16964.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,16991.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,16996.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17003.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17038.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17062.5,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17108.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17114.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17115.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17128.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17146.86,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,17206.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,17214.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,17262.96,11472.09)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17291.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,17318.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17326.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17330.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17362.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,17374.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,17413.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,17476,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,17476.54,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,17493.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17520.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17528.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,17554.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,17595.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17642.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,17649.28,293.42)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,17651.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17704.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,17729.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,17741.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17825.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,17831.23,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,17870.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,17874.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,17907.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,17911.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,17912.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,17944.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,18039.89,2330.17)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,18063.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18216,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18285.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,18298.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,18299.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18318.08,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,18354.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,18388.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,18408.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18446.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,18512.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,18520.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,18527.79,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,18531.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,18543.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,18547.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,18589.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,18604.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18635.79,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18655.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,18678.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,18680.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,18694.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,18695.31,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,18726.97,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18728.6,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,18754.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18767.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,18797.21,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,18831.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,18833.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,18836.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,18838.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,18881.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,18944.6,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,18968.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,18969.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,18978.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19026.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19027.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19091.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19096.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19113.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,19116.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,19141.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,19143.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19170.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19174.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,19177.53,331.6)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,19216.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19219.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19226.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19281.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,19339.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19349.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19457.43,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,19479.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,19479.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19481.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,19638.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19699.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19759.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19771.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19817.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,19854.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,19890.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,19916.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,20015.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,20068.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,20103.87,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,20177.34,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,20223.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,20239.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,20264.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,20283.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,20307.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,20344.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,20357.38,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,20386.79,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,20532.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,20535.6,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,20536.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,20539.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,20594.11,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,20708.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,20745.3,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,20754.2,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,20840.2,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,20856.05,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,20862.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,20862.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,20890.46,2109.16)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,20895.79,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,20937.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,20948.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,20976.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21064.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,21077.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21089.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,21113.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21127.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21213.81,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21214.06,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,21215.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,21257.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21270.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21277.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21310.34,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,21340.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21344.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21363.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,21364.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,21366.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21403.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21405.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21428.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21443.14,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21449.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21545.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21546,124.94)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,21595.2,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21611.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21616.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21630.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21677.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21680.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21721.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21738.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21765.93,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21779.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,21785.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21813.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,21917.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21953.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,21963.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,21971.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,21981.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,21994.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22044.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22080.59,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,22091.52,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22115.05,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22152.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22157.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,22244.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22244.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,22286.88,2091.64)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22312.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,22313.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22350.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,22358.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22402.46,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,22410.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22461.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22474.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22492.43,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22553.62,1091.51)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,22554.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,22558.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22559.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22592.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22606.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22641.07,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,22648.61,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22667.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22680.09,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22722.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,22735.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22768.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,22772.57,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,22775.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22791.75,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22843.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,22844.62,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22920.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,22943.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,22957.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,22975.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,22984.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23034,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23073.75,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23107.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23120.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23187.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23205.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,23250.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23305.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,23336.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,23342.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23344.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23404.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23414.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23433.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,23496.13,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23497.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23562.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,23587.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23588.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23614.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23701.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,23709.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,23829.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,23968.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,24004.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24009.91,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,24018.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24113.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,24119.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24237.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,24237.75,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,24243.85,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,24289.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24306.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,24330.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24383.17,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,24401.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,24413.08,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24437.62,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,24440.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,24486.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24507.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,24510.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,24530.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,24532.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,24566.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,24622.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24660.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24665.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,24691.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,24736.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24736.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24770.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,24786.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24800.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,24817.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,24858.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,24862.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,24913.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,24940.19,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,24944.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,25006.08,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,25034.35,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,25077.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,25098.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,25174.31,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,25214.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,25288.18,1028.21)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,25316.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,25531.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,25546.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,25575.89,5089.45)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,25576.32,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,25615.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,25699.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,25758.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,25775.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,25799.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,25884.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,25904.99,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,26125.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,26158.98,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,26202,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,26238.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,26249.52,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,26259.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,26361.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,26387.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,26409.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,26423.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,26464.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,26531.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,26542.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,26632.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,26633.45,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,26638.87,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,26658.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,26690.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,26723.5,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,26793.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,26931.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,26957.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,27028.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,27033.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27054.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,27088.55,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27124.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,27146.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,27167.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27169.08,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,27178.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,27199,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,27244.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,27397.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27414.26,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,27420.2,1218.39)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,27455.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27456.78,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27461.38,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27461.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,27503.52,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,27527.2,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27552.41,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27553.13,2699.3)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,27594.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27612.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27615.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,27650.74,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27672.7,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27694.1,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27706.8,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,27710.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,27739.55,5214.66)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,27859.84,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,27981.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,28014.54,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,28035.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,28072.49,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,28114.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,28155.69,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,28201.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,28240.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,28323.28,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,28329.25,2664.97)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,28337.51,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,28350.96,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,28373.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,28419.6,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,28516.03,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,28522.11,8720.1)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,28533.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,28533.12,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,28587.58,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,28592,329.95)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,28613.94,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,28621.42,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,28760.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,28802.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,28879.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,28897.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,28968.72,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,29124.27,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,29170.71,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,29196.01,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,29212.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,29240.83,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,29302.65,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,29311.88,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,29351.52,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,29357.66,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,29364.9,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,29384.18,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,29463.92,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,29665.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,29729.04,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,29743.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,29763.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,29782.06,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,29878.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,29950.79,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,29962.24,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,29963.82,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,29974.56,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,30020.05,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30094.68,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,30206.77,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,30277.53,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30289.39,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,30296.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,30317.76,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30345.89,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,30376.36,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30382.02,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30409.37,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,30452.4,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30465.47,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,30502.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30539.22,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,30643.33,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30670.15,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,30692.25,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,30697.73,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30758.93,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,30776.64,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (604,30811.44,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30878.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30884.08,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30884.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30895.48,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,30915.63,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (481,30981.67,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (530,30991.29,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (460,31093.16,0)
Insert Into EUS (PFC, Q24Max, Q24excess ) Values (493,31124.35,257.31)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-18 : 13:01:47

can you try this?


...
ORDER BY
	CASE 
		WHEN @so = 'Pct2' THEN 
			CASE WHEN coalesce(Month2.Q24excess, 0) = 0 
				OR coalesce(Month2.Q24max, 0) = 0 
			THEN 0 
			ELSE 
				Month2.Q24excess * 1.0 / Month2.Q24max
			END 
		WHEN @so = 'Excess2' THEN 
			coalesce(Month2.Q24excess, 0)
		ELSE EUS.PFC 
	END

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Stevan2020
Starting Member

25 Posts

Posted - 2012-09-18 : 13:16:41

Same incorrect order by:

PFC Pct2 Excess2
460 0.344297 12223.74
481 0.029885 595.99
530 0.046459 2368.05
604 0.831603 26162.73
493 1.059469 48914.78

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-18 : 13:29:59

what about this?


...
ORDER BY
	CASE 
		WHEN @so = 'Pct2' THEN 
			CASE WHEN coalesce(Month2.Q24excess, 0) = 0 
				OR coalesce(Month2.Q24max, 0) = 0 
			THEN 0.00 
			ELSE 
				Month2.Q24excess *1.0 / Month2.Q24max
			END 
		WHEN @so = 'Excess2' THEN 
			coalesce(Month2.Q24excess, 0)
		ELSE EUS.PFC  * 1.0
	END

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Stevan2020
Starting Member

25 Posts

Posted - 2012-09-18 : 13:40:07

Unfortunately, still the same incorrect order by

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-18 : 13:41:36

then i'm sure you're using some other query which is not completely posted here

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Stevan2020
Starting Member

25 Posts

Posted - 2012-09-18 : 13:54:23

Sorry, but no, I am running this using the data and query posted today, with the reduced code and dataset.

Have you tried to create the table and run the query?

Do you get different results?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-18 : 14:20:46

one thing i noticed is expression you've for Pct2 calculation is different from that in order by. i think you need to make them same if you want to get results sorted on it


Declare @so varchar(20)
Set @so = 'Pct2'

SELECT EUS.PFC AS PFC, 
	CASE WHEN coalesce(Month2.Q24excess, 0) = 0 
			OR coalesce(Month2.Q24max, 0) = 0 
		THEN 0 
		ELSE 
			100 * Month2.Q24excess / Month2.Q24max
	END AS Pct2, 
	coalesce(Month2.Q24excess, 0) AS Excess2 
FROM dbo.EUS AS EUS 
	LEFT JOIN ( SELECT EUS.PFC, 
								sum(coalesce(EUS.Q24excess, 0)) AS Q24excess,
								sum(coalesce(EUS.Q24max, 0)) AS Q24max 
							FROM dbo.EUS AS EUS 
							GROUP BY EUS.PFC 
						) AS Month2 ON EUS.PFC = Month2.PFC 
GROUP BY EUS.PFC, 
	Month2.Q24max, 
	Month2.Q24excess 
ORDER BY
	CASE 
		WHEN @so = 'Pct2' THEN 
			CASE WHEN coalesce(Month2.Q24excess, 0) = 0 
				OR coalesce(Month2.Q24max, 0) = 0 
			THEN 0 
			ELSE 
				100 * Month2.Q24excess / Month2.Q24max
			END 
		WHEN @so = 'Excess2' THEN 
			coalesce(Month2.Q24excess, 0)
		ELSE EUS.PFC 
	END

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Stevan2020
Starting Member

25 Posts

Posted - 2012-09-18 : 14:31:08

Thank you, thank you

I should have seen that.

You have made my day.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-18 : 14:37:12

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources