iVend Database Database : GetNextnumber User Defined Function

Creation Date

9/18/2015 10:14 AM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@newKey

In

BigInt

8

@siteId

In

Integer

4

@posSiteId

In

Integer

4

@numberToAdd

In

Integer

4

@RETURN_VALUE

Return Value

BigInt

8

CREATE FUNCTION [dbo].[GetNextnumber]

(

@newKey   BIGINT,

@siteId   INT,

@posSiteId INT,

@numberToAdd INT

)

RETURNS BIGINT

AS

BEGIN

DECLARE @lNextNumber BIGINT

SELECT @lNextNumber = CAST(SUBSTRING(CONVERT(NVARCHAR, @newKey + @numberToAdd), LEN(@siteId) + 1,

  LEN(CONVERT(NVARCHAR, @newKey + @numberToAdd))) AS BIGINT)

IF @posSiteId <> 0

BEGIN

SELECT @lNextNumber = CAST(SUBSTRING(CONVERT(NVARCHAR, @lNextNumber), LEN(@posSiteId) + 1,

  LEN(CONVERT(NVARCHAR, @lNextNumber))) AS BIGINT)

END

RETURN @lNextNumber;

END