search

oghenez / trade-software

Automatically exported from code.google.com/p/trade-software
2 stars 0 forks source link

Pricedatasum - highPrice trong table có giá trị nhỏ hơn openPrice #131

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Xem trong CSDL,
2. VNM
****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [stockCode]
      ,[type]
      ,[onDate]
      ,[openPrice]
      ,[closePrice]
      ,[lowPrice]
      ,[highPrice]
      ,[volume]
  FROM [stock].[dbo].[priceDataSum]
  where stockCode='VNM' and onDate>='2014-01-01' and type='D1'

Original issue reported on code.google.com by quan.ngu...@hqcorporation.net on 28 Jul 2014 at 9:51