USP_VENDOR1099_LINESPLITTER
Splits lines for report preview.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INPUTLINE | nvarchar(400) | IN | |
| @LINE1 | nvarchar(40) | INOUT | |
| @LINE2 | nvarchar(40) | INOUT |
Definition
Copy
create procedure dbo.USP_VENDOR1099_LINESPLITTER(
@INPUTLINE nvarchar(400)
,@LINE1 nvarchar(40) = null output
,@LINE2 nvarchar(40) = null output
)
as
begin
declare @Temp as nvarchar(40)
declare @LastIndex as int
set @LINE1 = ''
set @LINE2 = ''
set @Temp = @INPUTLINE
if CHARINDEX(' ', @INPUTLINE) > 0 AND CHARINDEX(' ', @INPUTLINE) < 40
set @LastIndex = 42 - CHARINDEX(' ',REVERSE(@Temp),0)
else
set @LastIndex = 41
set @LINE1 = RTRIM(SUBSTRING(@INPUTLINE, 0, @LastIndex))
set @LINE2 = LTRIM(SUBSTRING(@INPUTLINE, @LastIndex, 300))
end