+1

Nice way to enforce business rules on several tables into one rule.

It is also impossible to make an office active when the region is inactive.

My way would be to use...

The second Seelct returns "1".

I've answered with the following:

- Insert into table dbo.cuss1 generates an error msg

- Insert into table dbo.cuss2 generates an error msg

- Insert into table dbo.cuss2 does...

You can use ROW_NUMBER() in a CTE to select the Id's from the first post and filter on the row number.

DECLARE @T TABLE (

...

Try the following code,

DECLARE @Table_A TABLE (AB_Id nvarchar(5), A_Code nvarchar(5), Unit nvarchar(5), Line_Id int, PK_Id int)

INSERT @Table_A

SELECT 'FC002', '0041', '%', 1, 1

UNION SELECT 'FC002', '0043', '%', 1,...