McGehee, Robert wrote
> Hello,
> I have a table with dates and stock prices. Some of the prices are NULL
> because the stock did not trade on that day. In such instances, I'd like
> to replace the NULL value with the most recent non-NULL value, but I can't
> find an efficient way to do this.
Cann
Hello,
I have a table with dates and stock prices. Some of the prices are NULL because
the stock did not trade on that day. In such instances, I'd like to replace the
NULL value with the most recent non-NULL value, but I can't find an efficient
way to do this. I had thought a clever WINDOW funct