【数据处理】各门店销售库存数据导入

insert into xbxs
select * from [192.168.1.100].[scmis].[dbo].mdxs

delete from [192.168.1.100].[scmis].[dbo].mdxs

insert into dbxs
select * from [192.168.2.102].[scmis].[dbo].mdxs

delete from [192.168.2.102].[scmis].[dbo].mdxs

insert into zqxs
select * from [192.168.4.100].[scmis].[dbo].mdxs

delete from [192.168.4.100].[scmis].[dbo].mdxs

insert into gdxs
select * from [192.168.0.2].[scmis].[dbo].mdxs

delete from [192.168.0.2].[scmis].[dbo].mdxs

insert into tgxs

select * from [192.168.1.132].[scmis].[dbo].mdxs

delete from [192.168.1.132].[scmis].[dbo].mdxs

 

 

delete from sskc

insert into sskc
select pluno,sskc,'6015' from [192.168.1.100].[scmis].[dbo].实时库存

insert into sskc
select pluno,sskc,'7606' from [192.168.2.102].[scmis].[dbo].实时库存

insert into sskc
select pluno,sskc,'0004' from [192.168.4.100].[scmis].[dbo].实时库存

insert into sskc
select pluno,sskc,'0008' from [192.168.1.132].[scmis].[dbo].实时库存

 

select a.*,b.bcd into mdxs from nlgpossale('20150901','20151018') a ,商品码b b where a.pluno=b.pluno