USE [UFDATA_001_2014]
GO
/****** Object: StoredProcedure [dbo].[sp_jt_rdrecordSaleBillVouch] Script Date: 06/10/2015 11:28:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_jt_rdrecordSaleBillVouch]
-- Add the parameters for the stored procedure here
@dDatestar datetime, --起始出库日期
@dDateend datetime, --截至出库日期
@cCode nvarchar(30)='', --出库单号
@cCusAbbName nvarchar(60)='', --客户简称
@cBusCode nvarchar(30)='', --发货单号
@iordercode nvarchar(30)='', --销售订单号
@cSTCode nvarchar(20)='' --销售类型编码
AS
BEGIN
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[temporary]') AND type in (N'U'))
DROP TABLE [dbo].[temporary]
select
main.销售订单号,main.发货单号,main.出库单号,main.发货单