Archives of the TeradataForum
Message Posted: Fri, 17 Jan 2003 @ 18:02:33 GMT
| Subj: || || Re: Daily updates to a history table |
| From: || || krishnan |
Sorry I forgot to mention that there can be multiple updates to the account on the same day. If this is the case I think joining to the
existing table to get the previous account class will not work, so will I be better off using a stored procedure instead. Or is it going to
be a performance issue as it will be a row by row update and not a block update.