UFN_IMPORTPROCESSBATCH_GETHEADERROW

Returns the header row for an import process.

Return

Return Type
nvarchar(max)

Parameters

Parameter Parameter Type Mode Description
@BUSINESSPROCESSSTATUSID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_IMPORTPROCESSBATCH_GETHEADERROW(@BUSINESSPROCESSSTATUSID uniqueidentifier)
returns nvarchar(max)
as
begin

    declare @HEADERROW nvarchar(max);

    select @HEADERROW = IMPORTFILEHEADERROW from dbo.IMPORTPROCESSBATCH where BUSINESSPROCESSSTATUSID = @BUSINESSPROCESSSTATUSID;

    return @HEADERROW;

end;