-- ============================================= 
-- ������ Jeff
-- ��    ��:  V 1.0
-- �������ڣ� 2015-05-11
-- ����˵���� ֻ��dindan���м�¼,dindanjd�޼�¼�������,�����ж�������һ��������Ϊ"Ĭ�Ͼ���"��dindanjd��¼;
-- ��    ע�� ���ж�����������״̬��ΪOK,����Ա¼��; 
-- �޸����ڣ�  
-- �޸�˵����  
-- =============================================  

use [db]
go

declare @count int				--���嶩������;
declare @order nvarchar(32)		--���嶩����;
declare @date  nvarchar(16)		--��������;
declare @time  nvarchar(12)		--����ʱ��;
declare @waiter1 nvarchar(32)	--�������Ա1;
declare @waiter2 nvarchar(32)	--�������Ա2;
declare @waiter11 nvarchar(32)	--��������1;
declare @waiter22 nvarchar(32)	--��������2;
declare @bdate nvarchar(32)		--������������;
declare @inputtm nvarchar(32)	--����¼��ʱ��;
declare @status nvarchar(4)		--���嶩������״̬

set @date = datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())
set @time = datename(hour,getdate()) + ':' + datename(minute,getdate()) + ':' + datename(second,getdate())
set @inputtm = @date + ' ' + @time

select identity(int,1,1) as autoid,id,waiter1,waiter2,waiter12,waiter22,time1,[status] into #temp from dindan
select @count = max(autoid) from #temp

while( @count > 0)
begin
	select @order = id, @waiter1 = waiter1, @waiter2 = waiter2, @bdate = time1,@status = [status] from #temp where autoid = @count
	INSERT INTO [dindanjd]([id],[name],[date],[time],[waiter1],[waiter2],[status],[waiter12],[waiter22],[bookingdate],[dress],[bz],[clerk],[inputtime],[branch])
	VALUES(@order,'Ĭ�Ͼ���',@date,@time,@waiter1,@waiter2,@status,@waiter11,@waiter22,@bdate,'','','admin',@inputtm,'')
	set @count = @count - 1
end

drop table #temp