use TEST
go
create PROCEDURE [dbo].[SP_物料出入库周期]
(
@起始日期 VARCHAR(8),
@结束日期 VARCHAR(8)
@id char(3) output
)
AS
BEGIN
SET NOCOUNT ON; --当 SET NOCOUNT 为 ON 时,不返回计数。当 SET NOCOUNT 为 OFF 时,返回计数。
----------------删除临时表------------------------------------
--if object_id('tempdb..#TempA') is not null drop table #TempA;
--------------------------------------------------------------
select
INVMC.MC001 as '品号'
,MB002 as '品名'
,INVMC.MC002 as '仓库'
,CMSMC.MC002 as '仓库名称'
,INVMC.MC007 as '库存数量'
,INVMC.MC011 as '上次盘点日'
,INVMC.MC012 as '最近入库日'
,INVMC.MC013 as '最近出库日'
from INVMC ,INVMB ,CMSMC
where
INVMC.MC001 = MB001 and INVMC.MC002 = CMSMC.MC001
and ((INVMC.MC012 BETWEEN @起始日期 AND @结束日期 ) or (INVMC.MC013 BETWEEN @起始日期 AND @结束日期 ))
and INVMC.MC002 in ('101','102','103','104','106','110')
---------------------------------------------------------------
End
---------------------------------------------------------------
declare @id char(3)
exec TEST..SP_ASCII 90,90,57,@d = @id output
select @id as 序号
创建存储过程
原创
©著作权归作者所有:来自51CTO博客作者1097981的原创作品,请联系作者获取转载授权,否则将追究法律责任
上一篇:查询表、字段信息
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
mysql 存储过程返回更新前记录
mysql 存储过程返回更新前记录
存储过程 字段 自连接