SQL Merge Self-Referenced Tables

[Islamegy®]

I have 3 Self-Referenced SQL Table with the same structure
(Subj_ID,Parent_ID, SubjText, Notes) with the child/Parent relation between
Subj_ID, Parent_ID.
subj_ID in all tables starting from 1,

Now i need to merge my 3 tables in one table without lose or destroy the
child/parent relation.
Is there anyway to do so... need help plz

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

this question is better suited for a SQL NG, you may get a better answer
there

the problem I see is with your relationships, you will need to "translate"
the relationships in two of the tables to not collide with the others

one possible way:

- Detect the MAX( subj_ID ) frmo table 1
- disable the FK in table 2
- Sum MAX ( subj_ID ) to each of subj_ID and parent_id in table 2
- enable the FK in table 2
- repeat 1 .. 4 in tables 2, table 3

do a insert /select of the tables in the targt table
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Islamegy®" <Is******@Private.4me> wrote in message
news:e6**************@TK2MSFTNGP12.phx.gbl...

I have 3 Self-Referenced SQL Table with the same structure
(Subj_ID,Parent_ID, SubjText, Notes) with the child/Parent relation
between Subj_ID, Parent_ID.
subj_ID in all tables starting from 1,

Now i need to merge my 3 tables in one table without lose or destroy the
child/parent relation.
Is there anyway to do so... need help plz