�����B�i��I���f,�҂�ϵ�y�ڿ������yһ�޸ą���,Ȼ����ϵ�y�Ԅ��°l��ÿһ���T��,�@��������҂��Ĺ���Ч��,�����Еr��С�İ�һЩ���������ą���Ҳһ���°l��,�������a.
����a�޸ĺ�Ӱ푵Ĕ���:�Ñ��M��ϵ�y�ę���,ֵ�ΙC����;��ˮ������Ҫ�޸ķ��ԠI��Ʒ�Ŀ���,�N�۳ɱ�,����a��
��ˮ�����漰�ı���:tb_o_sg, tb_o_sm,tb_o_sg_today,tb_cursale
�����Z��:

select * into #tb_o_sg
from tb_o_sg
where c_store_id='1'
and datediff(day,c_datetime,getdate())=0

update #tb_o_sg
set c_deduct_rate=case when b.c_prom_deduct_rate<>0 then b.c_prom_deduct_rate else b.c_deduct_rate end,
 c_pt_cost=round(#tb_o_sg.c_price_disc*(1-0.01*case when b.c_prom_deduct_rate<>0 then b.c_prom_deduct_rate else b.c_deduct_rate end),2)
from tb_gdsprovider b
where #tb_o_sg.c_gds_type like '�ԠI%'
and #tb_o_sg.c_gcode=b.c_gcode
and b.c_status='��������'

update tb_o_sg
set c_deduct_rate=b.c_deduct_rate,c_pt_cost=b.c_pt_cost,c_store_id=dbo.uf_store_id()
from #tb_o_sg b
where tb_o_sg.c_guid=b.c_guid

update tb_o_sg_today
set c_deduct_rate=b.c_deduct_rate,c_pt_cost=b.c_pt_cost,c_store_id=dbo.uf_store_id()
from #tb_o_sg b
where tb_o_sg.c_guid=b.c_guid

update tb_o_sm
set c_store_id=dbo.uf_store_id()
where c_store_id='1'
and datediff(day,c_datetime,getdate())=0

delete tb_cursale
where datediff(day,c_datetime,getdate())=0

�����B�i��I߀���ֹ����{���ϼ��Č��r�N�۱O�y
������������Γ�,��ֻ��һһ���޸���