物料与供应商_物料_proc.sql

来自「SQL server 进销存软件数据库设计。大家积极下载」· SQL 代码 · 共 37 行

if exists (select name from sysobjects where name='物料与供应商_物料_PROC' and type='P')
drop PROC 物料与供应商_物料_PROC
go
create PROC 物料与供应商_物料_PROC
@item_to Varchar(30),
@item_fr Varchar(30)
AS
CREATE TABLE [#物料与供应商对照表]
 (
	[物料编码] [varchar] (30)  ,
	[计量单位] [varchar] (10)  ,
	[供应商编码] [varchar] (10)  ,
	[供应商物料编码] [varchar] (30),
	[货币码] [varchar] (10) ,
         税率编码 [varchar] (10) ,
	[订单计量单位] [varchar] (10)  ,
	[报价日期] [datetime] default(0) ,
	[分段数量1] [numeric](18, 6) default(0) ,
	[分段数量2] [numeric](18, 6)default(0) ,
	[分段数量3] [numeric](18, 6) default(0),
	[分段数量4] [numeric](18, 6) default(0) ,
	[分段数量5] [numeric](18, 6) default(0) ,
	[无税单位价格1_原币] [numeric](18, 6)default(0),
	[无税单位价格2_原币] [numeric](18, 6) default(0),
	[无税单位价格3_原币] [numeric](18, 6)default(0),
	[无税单位价格4_原币] [numeric](18, 6) default(0) ,
	[无税单位价格5_原币] [numeric](18, 6) default(0) ,
	[含税单位价格1_原币] [numeric](18, 6) default(0) ,
	[含税单位价格2_原币] [numeric](18, 6) default(0) ,
	[含税单位价格3_原币] [numeric](18, 6) default(0) ,
	[含税单位价格4_原币] [numeric](18, 6) default(0) ,
	[含税单位价格5_原币] [numeric](18, 6) default(0))
	
insert into #物料与供应商对照表 select *from 物料与供应商对照表
WHERE 物料编码>=@item_to and 物料编码<=@item_fr
SELECT *FROM #物料与供应商对照表