1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586 |
- use db
- select id,spid,name,growthtxname from dindansp where growthtxname = '全部' order by id
- go
- use db
- select id,spid,name,growthtxname from dindansp where id in(select id from dindansp where growthtxname = '全部') order by id
- go
- use db
- select id,spid,name,growthtxname from dindansp where id in(select id from dindansp where growthtxname = '全部')
- and growthtxname<>'第一次' and growthtxname<>'第二次'
- and growthtxname<>'第三次' and growthtxname<>'第四次'
- and growthtxname<>'第五次' and growthtxname<>'第六次'
- and growthtxname<>'第七次' and growthtxname<>'第八次'
- and growthtxname<>'第九次' and growthtxname<>'第十次'
- order by id
- go
- select * into dindansp
- go
- update dindansp set growthtxname=NULL where id in(select id from dindansp where growthtxname = '全部')
- and growthtxname not in('第一次','第二次','第三次','第四次','第五次','第六次','第七次','第八次','第九次','第十次')
- and name not in('入册','入底')
- go
- use db
- select id,spid,name,growthtxname from dindansp where id in(select id from dindansp where growthtxname = '全部') and
- growthtxname in('第一次','第二次','第三次','第四次','第五次','第六次','第七次','第八次','第九次','第十次')
- order by id
- go
- declare @size int
- declare @ord nvarchar(50)
- declare @spname nvarchar(50)
- declare @gname nvarchar(50)
- select @size=count(id) from dindansp where id in(select id from dindansp where growthtxname = '全部') and
- growthtxname in('第一次','第二次','第三次','第四次','第五次','第六次','第七次','第八次','第九次','第十次')
- while @size > 0
- begin
- select top 1 percent @ord=id,@spname=name,@gname=growthtxname from dindansp where id
- in(select id from dindansp where growthtxname = '全部')
- and growthtxname in('第一次','第二次','第三次','第四次','第五次','第六次','第七次','第八次','第九次','第十次')
- if
- end
- select distinct growthtxname from dindansp where id in(select id from dindansp where growthtxname = '全部') and
- growthtxname in('第一次','第二次','第三次','第四次','第五次','第六次','第七次','第八次','第九次','第十次')
- order by growthtxname
|