lyfz_repos/经典版源码/document/数据库维护脚本/dindan拍照时间为空,将dindanjd的拍照时间update到dindan拍照时间中.sql

--use db
--declare @date nvarchar(50)
--select @date=date from dindanjd where id='20150105-001' and [date] is not null
--update dindan set [time2] = @date where id='20150105-001'

--update dindan set [time2] = ''
--select date from dindanjd where date is not null and date <> ''
--select time2 from dindan where time2 <> ''
--
--select count(time2) from dindan where time2 = '' or time2 is null
--use [2014]
--select count(id) from dindan where isnull(time2,'')=''
--select count(id) from dindan where time2='' and time2 is not null

--select time2 from dindan where (time2='' or time2 is null) and id in(select id from dindanjd where date<>'' and date is not null)
--select time2 from dindan where id in(select id from dindanjd where date<>'' and date is not null)

--
use db
declare @orcount int			-- 满足条件的订单数量;
declare @orid nvarchar(50)		-- 满足条件的单个订单号;
declare @jddate nvarchar(50)	-- 满足条件的景点日期;
select @orcount=count(id) from dindan where (time2='' or time2 is null) and id in(select id from dindanjd where date<>'' and date is not null)
while @orcount > 0
begin
select top 1 percent @orid=id from dindan where (time2='' or time2 is null) and id in(select id from dindanjd where date<>'' and date is not null)
select @jddate=date from dindanjd where id = @orid and (date <> '' or date is not null)
if (@jddate <> '' and @jddate is not null)
	update dindan set time2 = @jddate where id = @orid
set @orcount=@orcount-1
end