USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTTRAVEL_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@ARRIVALTRAVELTYPEID	uniqueidentifier	INOUT
@ARRIVALTRAVELNAMEID	uniqueidentifier	INOUT
@ARRIVALNUMBER	nvarchar(25)	INOUT
@ARRIVALDATE	datetime	INOUT
@ARRIVALTIME	UDT_HOURMINUTE	INOUT
@DEPARTURETRAVELTYPEID	uniqueidentifier	INOUT
@DEPARTURETRAVELNAMEID	uniqueidentifier	INOUT
@DEPARTURENUMBER	nvarchar(25)	INOUT
@DEPARTUREDATE	datetime	INOUT
@DEPARTURETIME	UDT_HOURMINUTE	INOUT

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTTRAVEL_2
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @ARRIVALTRAVELTYPEID uniqueidentifier = null output,
    @ARRIVALTRAVELNAMEID uniqueidentifier = null output,
    @ARRIVALNUMBER nvarchar(25) = null output,
    @ARRIVALDATE datetime = null output,
    @ARRIVALTIME dbo.UDT_HOURMINUTE = null output,
    @DEPARTURETRAVELTYPEID uniqueidentifier = null output,
    @DEPARTURETRAVELNAMEID uniqueidentifier = null output,
    @DEPARTURENUMBER nvarchar(25) = null output,
    @DEPARTUREDATE datetime = null output,
    @DEPARTURETIME dbo.UDT_HOURMINUTE = null output
)
as

set nocount on;

set @DATALOADED = 0;
set @TSLONG = 0;

select 
    @DATALOADED = 1,
    @ARRIVALTRAVELTYPEID = REGISTRANTARRIVALTRAVELTYPECODEID,
    @ARRIVALTRAVELNAMEID = REGISTRANTARRIVALTRAVELNAMECODEID,
    @ARRIVALNUMBER = REGISTRANTTRAVEL.ARRIVALNUMBER,
    @ARRIVALDATE = REGISTRANTTRAVEL.ARRIVALDATE,
    @ARRIVALTIME = REGISTRANTTRAVEL.ARRIVALTIME,
    @DEPARTURETRAVELTYPEID = REGISTRANTDEPARTURETRAVELTYPECODEID,
    @DEPARTURETRAVELNAMEID = REGISTRANTDEPARTURETRAVELNAMECODEID,
    @DEPARTURENUMBER = REGISTRANTTRAVEL.DEPARTURENUMBER,
    @DEPARTUREDATE = REGISTRANTTRAVEL.DEPARTUREDATE,
    @DEPARTURETIME = REGISTRANTTRAVEL.DEPARTURETIME,
    @TSLONG = REGISTRANTTRAVEL.TSLONG
from 
    dbo.REGISTRANTTRAVEL
where 
    ID = @ID

return 0;