求树形数据表记录行的复制算法,高手请进!
现有一BOM树形数据表:dtMrpBomChild,表结构如下(ID为主键字段):
ID BomID ParentID MaterialID BomNum
01 Bom01 00 M001 1
02 Bom01 00 M002 1
03 Bom01 00 M003 1
04 Bom01 01 M004 2
05 Bom01 01 M005 2
06 Bom01 02 M006 2
07 Bom01 02 M007 2
如何用SQL语句或其它算法实现将以上的Bom1记录行在同一个表中复制为Bom2记录行:
ID BomID ParentID MaterialID BomNum
01 Bom01 00 M001 1
02 Bom01 00 M002 1
03 Bom01 00 M003 1
04 Bom01 01 M004 2
05 Bom01 01 M005 2
06 Bom01 02 M006 2
07 Bom01 02 M007 2
08 Bom02 00 M001 1
09 Bom02 00 M002 1
10 Bom02 00 M003 1
11 Bom02 08 M004 2
12 Bom02 08 M005 2
13 Bom02 09 M006 2
14 Bom02 09 M007 2
谢谢!