Posted by David Portas on 11/03/05 14:23
You didn't answer any of the questions I asked.
> companyid=(price(previousday)/price(currentday)-1)*100
Yes, but what is current and previous here? You cannot know which row
represents the previous day unless you have a date column or similar.
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|