What are disadvantage of using VIEW instead of table dbo.ProductsSequences.

The VIEW can return CategoryID and MAX(ProductID)?

Interesting solution, can you show me where can I find information how to implement 'sequence table'.

How can I improve my solution?

So there is a solution based on trigger INSTEAD OF INSERT:

DROP TABLE Product

GO

CREATE TABLE Product

(

[ProductID] int,

[CategoryID] int,

[Name] ...

1) About structure of real DB.

Don't think it's a good idea. The sample I've added fully describe the issue that requires solution.

2) About guess of object oriented structure

I do have...

I see your point, but the code I wrote is not a real DB structure.

You solution does not suit.

Ok, can you write a sample how to do that?

Jeff Moden (10/25/2008)

---

Paul,

It would help us give you a better answer quicker if you posted Table A and it's data in a readily "consumable" format. See the link in...

You have to aggregate, but what you can do is to add a fake column in which you then ignore.

This more or less gets want you want. I don't understand...