DECLARE    @return_value int

EXEC    @return_value = [dbo].[CWG_JSMX]
        @BDate = '2018-01-1',
        @EDate = '2018-01-31 23:59:59',
        @MD = N'XM002-B5'

SELECT    'Return Value' = @return_value

GO

 
ALTER PROC [dbo].[CWG_JSMX]
    (
      @BDate AS DATE ,
      @EDate AS DATE ,
      @MD AS VARCHAR(30)
    )
AS
    BEGIN 
        SELECT  t1.OrderCode ,
                @BDate AS JSBeginDt ,
                @EDate AS JSEndDt ,
                t1.OrderType ,
                t1.OrderTime ,
                t1.MemberCode , 
                od.FeeTotal
        FROM    dbo.S_Order AS t1
                LEFT JOIN dbo.S_OrderDetail od ON t1.ordercode = od.ordercode
        WHERE     t1.StoreCode = @MD
                AND ( 
                 t1.OrderTime >= @BDate
                      AND t1.OrderTime <= @EDate 
                    )
                    AND t1.PayStatus!='未支付'
    END    

GO