所有行业分类sql，带查找索引

CREATE TABLE [NT_Ex_Resumes_Jobs]( [JobId] [int] IDENTITY(1,1) NOT NULL, [JobName] [nvarchar](500) NULL, [ParentId] [int] NULL, [JobIndex] [nvarchar](max) NULL, CONSTRAINT [PK_NT_Ex_Resumes_Jobs] PRIMARY KEY CLUSTERED ( [JobId] ASC )WITH (

CREATE TABLE [NT_Ex_Resumes_Jobs](
[JobId] [int] IDENTITY(1,1) NOT NULL,
[JobName] [nvarchar](500) NULL,
[ParentId] [int] NULL,
[JobIndex] [nvarchar](max) NULL,
CONSTRAINT [PK_NT_Ex_Resumes_Jobs] PRIMARY KEY CLUSTERED
(
[JobId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
go
declare @JobIndex nvarchar(max),@ParentJobId int,@PParentJobId int,@TempPid int
set @JobIndex = (select MAX(JobId) from NT_Ex_Resumes_Jobs)
if @JobIndex is null
set @JobIndex = 1
else
set @JobIndex = @JobIndex + 1
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计算机/互联网/通信/电子',0,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计算机硬件',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机硬件')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='计算机硬件')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('高级硬件工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('硬件工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他1',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计算机软件',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机软件')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='计算机软件')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('高级软件工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('软件工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('软件UI设计师/工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('仿真应用工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('ERP实施顾问',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('ERP技术开发',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('需求工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统集成工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统分析员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统架构设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('数据库工程师/管理员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计算机辅助设计工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他2',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('互联网/电子商务/网游',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='互联网/电子商务/网游')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='互联网/电子商务/网游')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('互联网软件开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('多媒体/游戏开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站营运经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网络工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统管理员/网络管理员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站策划',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站编辑',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网页设计/制作/美工',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网络信息安全工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('智能大厦/综合布线',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他3',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站架构设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站维护工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('语音/视频开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('UI设计师/顾问',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网站营运专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('脚本开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('游戏策划师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('游戏界面设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('Flash设计/开发',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('特效设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('视觉设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('音效设计师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('SEO搜索引擎优化',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('产品经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('产品专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子商务经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子商务专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('网店店长/客服',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('IT-管理',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='IT-管理')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='IT-管理')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('首席技术执行官CTO/首席信息官CIO',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('技术总监/经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('信息技术经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('信息技术专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('项目总监',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('项目经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('项目主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('项目执行/协调人员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他4',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('IT-品管、技术支持及其它',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='IT-品管、技术支持及其它')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='IT-品管、技术支持及其它')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('技术支持/维护经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('技术支持/维护工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('计量工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('标准化工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('品质经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('系统测试',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('软件测试',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('硬件测试',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('测试员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('技术文员/助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他5',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('Helpdesk 技术支持',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('文档工程师',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('通信技术开发及应用',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='通信技术开发及应用')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='通信技术开发及应用')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('通信技术工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('有线传输工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('无线通信工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电信交换工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('数据通信工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('移动通信工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电信网络工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('通信电源工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他6',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('增值产品开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('手机软件开发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('手机应用开发工程师',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='计算机/互联网/通信/电子')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子/电器/半导体/仪器仪表',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='电子/电器/半导体/仪器仪表')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='电子/电器/半导体/仪器仪表')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('集成电路IC设计/应用工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('IC验证工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子工程师/技术员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电气工程师/技术员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电路工程师/技术员(模拟/数字)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电声/音响工程师/技术员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('半导体技术',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('自动控制工程师/技术员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子软件开发(ARM/MCU...)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('嵌入式软件开发(Linux/单片机/DLC/DSP…)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电池/电源开发',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('FAE 现场应用工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('家用电器/数码产品研发',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('仪器/仪表/计量分析师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('测试工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他7',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子技术研发工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('激光/光电子技术',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('嵌入式硬件开发(主板机…)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电子/电器维修工程师/技师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('变压器与磁电工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('版图设计工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('工艺工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('射频工程师',@ParentJobId,@JobIndex)
set @JobIndex = (select MAX(JobId) from NT_Ex_Resumes_Jobs)
if @JobIndex is null
set @JobIndex = 1
else
set @JobIndex = @JobIndex + 1
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售/客服/技术支持',0,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售/客服/技术支持')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售管理',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售管理')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='销售管理')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售总监',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('业务拓展主管/经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('渠道/分销总监',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('渠道/分销经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('渠道/分销主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('大客户经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客户经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('区域销售总监',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('区域销售经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('团购经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他8',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售/客服/技术支持')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售人员',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售人员')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='销售人员')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售代表',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('渠道/分销专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客户代表',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('电话销售',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('经销商',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他9',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('团购业务员',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售/客服/技术支持')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售行政及商务',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售行政及商务')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='销售行政及商务')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售行政经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售行政专员/助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('商务经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('商务主管/专员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('商务助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('销售助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他10',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('业务分析经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('业务分析专员/助理',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='销售/客服/技术支持')
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex = CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服及技术支持',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='客服及技术支持')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='客服及技术支持')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服总监(非技术)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服经理(非技术)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服主管(非技术)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客服专员/助理(非技术)',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('售前/售后技术支持经理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('售前/售后技术支持主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('售前/售后技术支持工程师',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('咨询热线/呼叫中心服务人员',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('其他11',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('客户关系经理/主管',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('投诉专员',@ParentJobId,@JobIndex