use TEST
go
create PROCEDURE [dbo].[SP_物料出入庫(kù)周期]
(
    @起始日期 VARCHAR(8),
    @結(jié)束日期 VARCHAR(8)
    @id char(3) output
) 
AS
BEGIN
    SET NOCOUNT ON;             --當(dāng) SET NOCOUNT 為 ON 時(shí)，不返回計(jì)數(shù)。當(dāng) SET NOCOUNT 為 OFF 時(shí)，返回計(jì)數(shù)。
----------------刪除臨時(shí)表------------------------------------
--if object_id('tempdb..#TempA') is not null drop table #TempA; 
--------------------------------------------------------------
select 
 INVMC.MC001 as '品號(hào)' 
,MB002 as '品名'
,INVMC.MC002 as '倉(cāng)庫(kù)' 
,CMSMC.MC002 as '倉(cāng)庫(kù)名稱'
,INVMC.MC007 as '庫(kù)存數(shù)量' 
,INVMC.MC011 as '上次盤點(diǎn)日' 
,INVMC.MC012 as '最近入庫(kù)日' 
,INVMC.MC013 as '最近出庫(kù)日' 
 from INVMC ,INVMB ,CMSMC
 where 
    INVMC.MC001 = MB001 and INVMC.MC002 = CMSMC.MC001
    and ((INVMC.MC012 BETWEEN @起始日期 AND @結(jié)束日期 ) or (INVMC.MC013 BETWEEN @起始日期 AND @結(jié)束日期 ))
    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 序號(hào)