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
--

[Back to original message]