国产99久久精品_欧美日本韩国一区二区_激情小说综合网_欧美一级二级视频_午夜av电影_日本久久精品视频

最新文章專題視頻專題問(wèn)答1問(wèn)答10問(wèn)答100問(wèn)答1000問(wèn)答2000關(guān)鍵字專題1關(guān)鍵字專題50關(guān)鍵字專題500關(guān)鍵字專題1500TAG最新視頻文章推薦1 推薦3 推薦5 推薦7 推薦9 推薦11 推薦13 推薦15 推薦17 推薦19 推薦21 推薦23 推薦25 推薦27 推薦29 推薦31 推薦33 推薦35 推薦37視頻文章20視頻文章30視頻文章40視頻文章50視頻文章60 視頻文章70視頻文章80視頻文章90視頻文章100視頻文章120視頻文章140 視頻2關(guān)鍵字專題關(guān)鍵字專題tag2tag3文章專題文章專題2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章專題3
問(wèn)答文章1 問(wèn)答文章501 問(wèn)答文章1001 問(wèn)答文章1501 問(wèn)答文章2001 問(wèn)答文章2501 問(wèn)答文章3001 問(wèn)答文章3501 問(wèn)答文章4001 問(wèn)答文章4501 問(wèn)答文章5001 問(wèn)答文章5501 問(wèn)答文章6001 問(wèn)答文章6501 問(wèn)答文章7001 問(wèn)答文章7501 問(wèn)答文章8001 問(wèn)答文章8501 問(wèn)答文章9001 問(wèn)答文章9501
當(dāng)前位置: 首頁(yè) - 科技 - 知識(shí)百科 - 正文

所有行業(yè)分類sql,帶查找索引

來(lái)源:懂視網(wǎng) 責(zé)編:小采 時(shí)間:2020-11-09 10:10:42
文檔

所有行業(yè)分類sql,帶查找索引

所有行業(yè)分類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 (
推薦度:
導(dǎo)讀所有行業(yè)分類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 (

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 ('計(jì)算機(jī)/互聯(lián)網(wǎng)/通信/電子',0,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計(jì)算機(jī)/互聯(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 ('計(jì)算機(jī)硬件',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計(jì)算機(jī)硬件')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='計(jì)算機(jī)硬件')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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í)硬件工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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='計(jì)算機(jī)/互聯(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 ('計(jì)算機(jī)軟件',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計(jì)算機(jī)軟件')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='計(jì)算機(jī)軟件')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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í)軟件工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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è)計(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 ('仿真應(yī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 ('ERP實(shí)施顧問(wè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 ('ERP技術(shù)開(kāi)發(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è)計(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ù)據(jù)庫(kù)工程師/管理員',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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ì)算機(jī)輔助設(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 ('其他2',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計(jì)算機(jī)/互聯(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ù)/網(wǎng)游',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='互聯(lián)網(wǎng)/電子商務(wù)/網(wǎng)游')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='互聯(lián)網(wǎng)/電子商務(wù)/網(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)軟件開(kāi)發(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 ('多媒體/游戲開(kāi)發(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)站營(yíng)運(yù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 ('網(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)頁(yè)設(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 ('網(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è)計(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 ('網(wǎng)站維護(hù)工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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ǔ)音/視頻開(kāi)發(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è)計(jì)師/顧問(wè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 ('網(wǎng)站營(yíng)運(yù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 ('腳本開(kāi)發(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è)計(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 ('Flash設(shè)計(jì)/開(kāi)發(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è)計(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 ('視覺(jué)設(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è)計(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 ('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 ('電子商務(wù)經(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ù)專員',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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)店店長(zhǎng)/客服',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計(jì)算機(jī)/互聯(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 ('項(xiàng)目總監(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 ('項(xià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 ('項(xià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 ('項(xiàng)目執(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='計(jì)算機(jī)/互聯(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ù)支持/維護(hù)經(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ù)支持/維護(hù)工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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ì)量工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('標(biāo)準(zhǔ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 ('品質(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)測(cè)試',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('軟件測(cè)試',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('硬件測(cè)試',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_Jobs)
set @JobIndex =CAST(@PParentJobId as nvarchar(50))+'|'+CAST(@ParentJobId as nvarchar(50))+'|'+@JobIndex
insert into [NT_Ex_Resumes_Jobs] ([JobName] ,[ParentId],[JobIndex])
VALUES ('測(cè)試員',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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='計(jì)算機(jī)/互聯(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ù)開(kāi)發(fā)及應(yīng)用',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='通信技術(shù)開(kāi)發(fā)及應(yīng)用')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='通信技術(shù)開(kāi)發(fā)及應(yī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 ('通信技術(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 ('無(wú)線通信工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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 ('移動(dò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 ('通信電源工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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)品開(kāi)發(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 ('手機(jī)軟件開(kāi)發(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 ('手機(jī)應(yīng)用開(kāi)發(fā)工程師',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='計(jì)算機(jī)/互聯(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 ('電子/電器/半導(dǎo)體/儀器儀表',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='電子/電器/半導(dǎo)體/儀器儀表')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='電子/電器/半導(dǎo)體/儀器儀表')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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è)計(jì)/應(yī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 ('IC驗(yà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ù)員',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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 ('半導(dǎo)體技術(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 ('自動(dò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 ('電子軟件開(kāi)發(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 ('嵌入式軟件開(kāi)發(fā)(Linux/單片機(jī)/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 ('電池/電源開(kāi)發(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)場(chǎng)應(yī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ù)碼產(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 ('儀器/儀表/計(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 ('測(cè)試工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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 ('嵌入式硬件開(kāi)發(fā)(主板機(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 ('變壓器與磁電工程師',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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 ('射頻工程師',@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è)務(wù)拓展主管/經(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 ('團(tuán)購(gòu)經(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 ('團(tuán)購(gòu)業(yè)務(wù)員',@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 ('銷售行政及商務(wù)',@ParentJobId,@JobIndex)
set @ParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobName='銷售行政及商務(wù)')
set @TempPid = (select ParentId from NT_Ex_Resumes_Jobs where JobName='銷售行政及商務(wù)')
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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ù)經(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ù)主管/專員',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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ù)助理',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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è)務(wù)分析經(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è)務(wù)分析專員/助理',@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 ('咨詢熱線/呼叫中心服務(wù)人員',@ParentJobId,@JobIndex)
set @PParentJobId = (select JobId from NT_Ex_Resumes_Jobs where JobId = @TempPid)
set @JobIndex = (select MAX(JobId)+1 from NT_Ex_Resumes_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)頁(yè)內(nèi)容旨在傳播知識(shí),若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系,我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

文檔

所有行業(yè)分類sql,帶查找索引

所有行業(yè)分類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 (
推薦度:
標(biāo)簽: 查詢 查找 分類
  • 熱門焦點(diǎn)

最新推薦

猜你喜歡

熱門推薦

專題
Top
主站蜘蛛池模板: 久久福利一区二区 | 国产网站在线 | 在线视频亚洲 | 日韩福利在线 | 一久久| 日韩欧美在线观看成人 | 五月天色综合 | 亚洲欧美中文日韩在线v日本 | 好看的电影网站亚洲一区 | 亚洲一区中文字幕在线观看 | 日韩一区二区三区免费 | 狠狠色狠狠色综合日日不卡 | 欧美a在线观看 | 亚洲一区二区三区精品视频 | 亚洲图欧美 | 欧美日韩操 | 国产精品一区二区久久精品 | 国产欧美成人一区二区三区 | 精品久久久久久久中文字幕 | 日本国产一区 | 国产丝袜在线视频 | 亚洲精品午夜国产va久久成人 | 中文字幕第7页 | 国产伦精品一区二区三区免费下载 | 99热只有精品一区二区 | 黄色网站在线观看视频 | 在线精品免费视频 | 欧美第一页在线 | 亚洲最新视频在线观看 | 久久99久久99精品 | 国产精品成人一区二区1 | 中文字幕在线不卡视频 | 亚洲欧美日韩在线精品一区二区 | 日韩一区二区三区视频 | www.国产精品 | 日韩高清dvd | 亚洲精品免费观看 | 欧美 日韩 亚洲另类专区 | 高清国产美女一级a毛片 | 中文字幕韩国电影 | 国产99久久精品一区二区 |