I need to create a numeric value (*EntryID) for each ID that is listed more than once in a table, for example:
ID ContractID EntryID
-- ---------- -------
12 1 1
12 1 2
12 1 3
12 2 1
So long as the ID and Contract are the same over several rows I need to add a "Counter" field...any suggestions are greatly appreciated.
ID ContractID EntryID
-- ---------- -------
12 1 1
12 1 2
12 1 3
12 2 1
So long as the ID and Contract are the same over several rows I need to add a "Counter" field...any suggestions are greatly appreciated.