CREATE TABLE [dbo].[Data0025](
[RKEY] [int] NOT NULL,
[MANU_PART_NUMBER] [varchar](20) NULL,
[PARENT_PTR] [int] NULL,
)
select * from [Data0025]
insert into Data0025(RKEY,MANU_PART_NUMBER,PARENT_PTR)
values(26949,'l1-l8',0),
(26950,'l1-l4',26949),
(26951,'l5-l8',26949),
(26952,'l1-l2',26950),
(26953,'l3-l4',26950),
(26954,'l5-l6',26951),
(26955,'l7-l8',26951)，
(36949,'l1-l6',0),
(36950,'l2-l5',36949),
(36951,'l3-l4',36950)
現有一個臨時表#T，存放資料
CREATE TABLE #T(
[RKEY] [int] NOT NULL,
[MANU_PART_NUMBER] [varchar](20) NULL,
[PARENT_PTR] [int] NULL,
)
insert into #T(RKEY,MANU_PART_NUMBER,PARENT_PTR)
values
(26955,'l7-l8',26951)，
(36951,'l3-l4',36950)
想根據臨時表#T中資料，查詢出所有上級資料并寫入臨時表#TT
查詢資料如下：
26949,'l1-l8',0
26951,'l5-l8',26949
36949,'l1-l6',0
36950,'l2-l5',36949
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/216516.html
標籤：疑難問題
下一篇：python工具類