Hi All -
Relatively simple idea here, but one that has me a bit stumped as to the best solution. I want to create an MS SQL table that will store comments related to account issues. I want to identify, in a composite key, the account number and the incremental comment number (1, 2, 3). When a new account number is added, again I want to identify that comment number incrementally. A composite of ACCT_NUM (integer) and COMMENT_NUM (identity integer) works for the first account, but the identity number will continue upward indefinitely and will not properly reset to number the comment by account.
So, experts, any ideas to create the following? The preference would be that it happens at the table level, and not in an insert command (if possible)!