lyfz_repos/经典版源码/document/数据库维护脚本/订单报表双击记录对话框空白处理方法.sql

use [db]
declare @Myid nvarchar(50)			-- 要获取的订单号;
declare @Myname1 nvarchar(50)		-- 要获取的顾客姓名1;
declare @Myname2 nvarchar(50)		-- 要获取的顾客姓名2;
declare @MyCount int				-- 要处理的订单总数;

-- 查询出要处理的订单总数;
select @MyCount=count(id) from dindan where id not in(select id from client)
-- 循环处理要处理的订单;
while @MyCount > 0 begin
select top 1 percent @Myid=id,@Myname1=name1,@Myname2=name2 from dindan where id not in(select id from client)
insert into client(id,name1,name2)values(@Myid,@Myname1,@Myname2)
select @MyCount=count(id) from dindan where id not in(select id from client)
end