Posted by David Portas on 09/29/05 22:02

Probably something like this. I'm guessing you have an Accounts table
somewhere as well.

CREATE TABLE account_balances
(account_no INTEGER NOT NULL
CONSTRAINT fk_account_balances_accounts
FOREIGN KEY REFERENCES accounts (account_no)
,balance_date DATETIME NOT NULL
,balance NUMERIC(19,4) NOT NULL,
CONSTRAINT pk_account_balances
PRIMARY KEY (account_no,balance_date)) ;

--
David Portas
SQL Server MVP
--

[Back to original message]