Posted by kalikoi on 11/03/05 14:29

Hi David Portas

here col2 values are arranged in the descending order of date

this is the query is used

select companyid,latestclosingprice into #Tempone from
backscreeningdata3 where dailydate
between '12/3/04' and '01/05/05' order by companyid,dailydate desc


Hope U understand


Thanks & Regards
kalyan

[Back to original message]