[Quantproject-developers] QuantProject/b2_DataAccess/Tables Quotes.cs, 1.32, 1.33

[Marco M. <mi...@us...>]

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv2167/b2_DataAccess/Tables

Modified Files:
	Quotes.cs 
Log Message:
Fixed bug in sql statement

Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v
retrieving revision 1.32
retrieving revision 1.33
diff -C2 -d -r1.32 -r1.33
*** Quotes.cs	8 Apr 2007 18:59:45 -0000	1.32
--- Quotes.cs	8 Apr 2008 21:38:41 -0000	1.33
***************
*** 475,479 ****
  		{
  			string sql = "SELECT TOP " + maxNumOfReturnedTickers + " tickers.tiTicker, tickers.tiCompanyName, " +
! 				"Avg([quVolume]) AS AverageTradedValue " +
  				"FROM quotes INNER JOIN (tickers INNER JOIN tickers_tickerGroups " +
  				"ON tickers.tiTicker = tickers_tickerGroups.ttTiId) " +
--- 475,479 ----
  		{
  			string sql = "SELECT TOP " + maxNumOfReturnedTickers + " tickers.tiTicker, tickers.tiCompanyName, " +
! 				"Avg([quVolume]*[quClose]) AS AverageTradedValue " +
  				"FROM quotes INNER JOIN (tickers INNER JOIN tickers_tickerGroups " +
  				"ON tickers.tiTicker = tickers_tickerGroups.ttTiId) " +