|
Posted by Alexander Kuznetsov on 06/07/06 17:38
Erland Sommarskog wrote:
>
> Having watched the thread from aside, I think the real problem is that
> the data model needs improvement. I would add a bit column "isbalanceentry"
> or some such. And of course add a primary key. (InvoiceNumber,
> isbalanceentry) looks like a candidate.
>
I concur that the schema might need some work. I was thinking that a
single nullable column negated_date might be sufficient, so that
instead of inserting one more row one just needs to update negated_date.
Navigation:
[Reply to this message]
|