您好, 可以通过下面这个语句处理,总部处理完毕后,分发下全部数据分店下传。 --先执行, select b.item_no ,b.branch_no ,b.supcust_no ,b.appointed_price ,b.top_price ,b.bottom_price ,b.last_price ,b.sale_way ,b.[contract_date] ,b.[memo] ,b.[other1] ,b.[other2] ,b.[other3] ,b.[num1] ,b.[num2] ,b.[num3] ,b.[pur_status] ,b.[direct_flag] ,b.[default_flag] ,b.[contract_no] into t_bd_supcust_item_2 from t_pc_branch_price a,t_bd_supcust_item b where a.item_no = b.item_no and a.branch_no = b.branch_no and a.supcust_no = b.supcust_no --再执行 drop table t_bd_supcust_item go USE [hbposepro] GO /****** Object: Table [dbo].[t_bd_supcust_item] Script Date: 08/06/2020 09:18:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[t_bd_supcust_item]( [item_no] [char](20) NOT NULL, [branch_no] [char](6) NOT NULL, [supcust_no] [char](8) NOT NULL, [appointed_price] [numeric](16, 4) NULL, [top_price] [numeric](16, 4) NULL, [bottom_price] [numeric](16, 4) NULL, [last_price] [numeric](16, 4) NULL, [sale_way] [char](1) NULL, [contract_date] [dbo].[u_date] NULL, [memo] [varchar](255) NULL, [other1] [varchar](20) NULL, [other2] [varchar](20) NULL, [other3] [varchar](20) NULL, [num1] [numeric](16, 4) NULL, [num2] [numeric](16, 4) NULL, [num3] [numeric](16, 4) NULL, [pur_status] [char](1) NULL, [direct_flag] [char](1) NULL, [default_flag] [char](1) NULL, [contract_no] [varchar](20) NULL, CONSTRAINT [PK_T_BD_SUPCUST_ITEM] PRIMARY KEY CLUSTERED ( [item_no] ASC, [branch_no] ASC, [supcust_no] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT (0) FOR [appointed_price] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT (0) FOR [top_price] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT (0) FOR [bottom_price] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT (0) FOR [last_price] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT ('A') FOR [sale_way] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT (0) FOR [num1] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT (0) FOR [num2] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT (0) FOR [num3] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT ('1') FOR [pur_status] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT ('0') FOR [direct_flag] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD DEFAULT ('0') FOR [default_flag] GO --最后执行 insert into t_bd_supcust_item select * from t_bd_supcust_item_2 感谢您的支持。 |