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 ('計算機/互聯(lián)網(wǎng)/通信/電子',0,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計算機/互聯(lián)網(wǎng)/通信/電子')
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='計算機/互聯(lián)網(wǎng)/通信/電子')
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設(shè)計師/工程師',@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技術(shù)開發(fā)',@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 ('系統(tǒng)集成工程師',@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 ('系統(tǒng)分析員',@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 ('系統(tǒng)工程師',@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 ('系統(tǒng)架構(gòu)設(shè)計師',@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 ('數(shù)據(jù)庫工程師/管理員',@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 ('計算機輔助設(shè)計工程師',@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='計算機/互聯(lián)網(wǎng)/通信/電子')
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 ('互聯(lián)網(wǎng)/電子商務/網(wǎng)游',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='互聯(lián)網(wǎng)/電子商務/網(wǎng)游')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='互聯(lián)網(wǎng)/電子商務/網(wǎng)游')
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 ('互聯(lián)網(wǎng)軟件開發(fā)工程師',@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 ('多媒體/游戲開發(fā)工程師',@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 ('網(wǎng)站營運經(jīng)理/主管',@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 ('網(wǎng)絡(luò)工程師',@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 ('系統(tǒng)管理員/網(wǎng)絡(luò)管理員',@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 ('網(wǎng)站策劃',@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 ('網(wǎng)站編輯',@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 ('網(wǎng)頁設(shè)計/制作/美工',@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 ('網(wǎng)絡(luò)信息安全工程師',@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 ('網(wǎng)站架構(gòu)設(shè)計師',@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 ('網(wǎng)站維護工程師',@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 ('語音/視頻開發(fā)工程師',@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設(shè)計師/顧問',@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 ('網(wǎng)站營運專員',@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 ('腳本開發(fā)工程師',@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 ('游戲界面設(shè)計師',@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設(shè)計/開發(fā)',@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 ('特效設(shè)計師',@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 ('視覺設(shè)計師',@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 ('音效設(shè)計師',@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搜索引擎優(yōu)化',@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 ('產(chǎn)品經(jīng)理/主管',@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 ('產(chǎn)品專員',@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 ('電子商務經(jīng)理/主管',@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 ('網(wǎng)店店長/客服',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計算機/互聯(lián)網(wǎng)/通信/電子')
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 ('首席技術(shù)執(zhí)行官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 ('技術(shù)總監(jiān)/經(jīng)理',@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 ('信息技術(shù)經(jīng)理/主管',@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 ('信息技術(shù)專員',@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 ('項目總監(jiān)',@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 ('項目經(jīng)理',@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 ('項目執(zhí)行/協(xié)調(diào)人員',@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='計算機/互聯(lián)網(wǎng)/通信/電子')
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-品管、技術(shù)支持及其它',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='IT-品管、技術(shù)支持及其它')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='IT-品管、技術(shù)支持及其它')
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 ('技術(shù)支持/維護經(jīng)理',@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 ('技術(shù)支持/維護工程師',@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 ('品質(zhì)經(jīng)理',@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 ('系統(tǒng)測試',@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 ('技術(shù)文員/助理',@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 技術(shù)支持',@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='計算機/互聯(lián)網(wǎng)/通信/電子')
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 ('通信技術(shù)開發(fā)及應用',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='通信技術(shù)開發(fā)及應用')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='通信技術(shù)開發(fā)及應用')
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 ('通信技術(shù)工程師',@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 ('數(shù)據(jù)通信工程師',@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 ('電信網(wǎng)絡(luò)工程師',@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 ('增值產(chǎn)品開發(fā)工程師',@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 ('手機軟件開發(fā)工程師',@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 ('手機應用開發(fā)工程師',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計算機/互聯(lián)網(wǎng)/通信/電子')
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設(shè)計/應用工程師',@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 ('電子工程師/技術(shù)員',@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 ('電氣工程師/技術(shù)員',@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 ('電路工程師/技術(shù)員(模擬/數(shù)字)',@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 ('電聲/音響工程師/技術(shù)員',@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 ('半導體技術(shù)',@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 ('自動控制工程師/技術(shù)員',@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 ('電子軟件開發(fā)(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 ('嵌入式軟件開發(fā)(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 ('電池/電源開發(fā)',@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 現(xiàn)場應用工程師',@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 ('家用電器/數(shù)碼產(chǎn)品研發(fā)',@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 ('電子技術(shù)研發(fā)工程師',@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 ('激光/光電子技術(shù)',@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 ('嵌入式硬件開發(fā)(主板機…)',@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 ('版圖設(shè)計工程師',@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 ('銷售/客服/技術(shù)支持',0,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='銷售/客服/技術(shù)支持')
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 ('銷售總監(jiān)',@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 ('銷售經(jīng)理',@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 ('業(yè)務拓展主管/經(jīng)理',@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 ('渠道/分銷總監(jiān)',@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 ('渠道/分銷經(jīng)理',@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 ('大客戶經(jīng)理',@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 ('客戶經(jīng)理/主管',@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 ('區(qū)域銷售總監(jiān)',@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 ('區(qū)域銷售經(jīng)理',@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 ('團購經(jīng)理/主管',@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='銷售/客服/技術(shù)支持')
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 ('經(jīng)銷商',@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 ('團購業(yè)務員',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='銷售/客服/技術(shù)支持')
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 ('銷售行政經(jīng)理/主管',@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 ('商務經(jīng)理',@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 ('業(yè)務分析經(jīng)理/主管',@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 ('業(yè)務分析專員/助理',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='銷售/客服/技術(shù)支持')
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 ('客服及技術(shù)支持',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='客服及技術(shù)支持')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='客服及技術(shù)支持')
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 ('客服總監(jiān)(非技術(shù))',@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 ('客服經(jīng)理(非技術(shù))',@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 ('客服主管(非技術(shù))',@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 ('客服專員/助理(非技術(shù))',@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 ('售前/售后技術(shù)支持經(jīng)理',@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 ('售前/售后技術(shù)支持主管',@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 ('售前/售后技術(shù)支持工程師',@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 ('客戶關(guān)系經(jīng)理/主管',@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

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com