Archive for July, 2009

get rows of dynamic latest date(s)

Posted on July 30, 2009. Filed under: Firebird | Tags: database, Firebird, programming, sql |

…. sorry for not updating for such a long time.
just got a mail from a friend recently. probably this is some idea to share:
—
yo, Byeol. got a problem here. I have a table (FB) where I need to store every month’s stock of any available Product:

CREATE TABLE TSTOCK (
THEDATE DATE NOT NULL,
PRODUCTID VARCHAR(30) NOT NULL,
COST DOUBLE PRECISION [...]