I have a question about Incremental values. I am still getting into SQL Server but I had this thought.

Can a value be incremented within a certain boundary and then be reset to 1?

In other words, I have a table with:

Column A Column B Column C
D001 B5 1
D001 B5 2
D001 B5 3
D002 B5 1
D003 B3 1

Where Column C is an incrementing column that is dependent on the combined value of Columns A and B. Is this possible in SQL Server? Or do I need to create either a function/stored proc or handle it in my client?


TIA

Richard