存储过程 记录存根

CREATE PROCEDURE [dbo].[P_ImportPOSExcel]
(
--@agentReseller varchar(100),--Reseller导入名
--@agentMateriaName varchar(50),--物料导入名
@agentName varchar(20)
) 
AS
 
CREATE Table #contrast_reseller --代理Reseller对照表
(
F_YEA_AgentID varchar(20),
F_YEA_AGENTRESELLER varchar(100),
F_YEA_ReSeller varchar(20)
)


CREATE Table #contrast_material --代理机型对照表
(
F_YEA_AgentID varchar(20),
F_YEA_AGENTMATERIANAME varchar(100),
F_YEA_MATERIALID varchar(20)
)


CREATE table #OutPOSData --要返回出去的结果表 
(
agent varchar(50),
Reseller varchar(100) ,
sysReseller varchar(100),
    MaterialType varchar(50) ,
sysMaterialType varchar(50),
    Qty varchar(20) ,
    SaleDate varchar(20) ,
    Unitprice varchar(20),
ActPrice float,
SMRPPrice float )
  
BEGIN


----将EXCEL数据插入到临时表


INSERT INTO #OutPOSData(agent,Reseller,MaterialType,Qty,SaleDate,Unitprice)
SELECT @agentName,Reseller,MaterialType,Qty,SaleDate,Unitprice FROM POSData


----获取Reseller对照表

INSERT INTO #contrast_rese